none
Is it possible to see the most frequently asked questions in the knowledge base?

    Question

  • Referencing the article from Microsoft's Documentation titled "Get analytics on your knowledge base".

    Is there a way to adjust the query below to display the most frequently asked questions?

    requests
        | where url endswith "generateAnswer"
        | project timestamp, id, name, resultCode, duration
        | parse name with *"/knowledgebases/"KbId"/generateAnswer"
        | join kind= inner (
        traces | extend id = operation_ParentId
        ) on id
        | extend question = tostring(customDimensions['Question'])
        | extend answer = tostring(customDimensions['Answer'])
        | project KbId, timestamp, resultCode, duration, question, answer

    Thanks in advance!

    Thursday, December 27, 2018 4:23 PM

All replies

  • Hi tsilbern,

    Thanks for using Azure Application Insights.

    To get the most frequently asked question , you can see if the below query fits your need. You can always get more frequently asked questions by changing the number of Top results  in the query. 

    requests

        | where url endswith "generateAnswer"

        | project timestamp, id, name, resultCode, duration

        | parse name with *"/knowledgebases/"KbId"/generateAnswer"

        | join kind= inner (

        traces | extend id = operation_ParentId

        ) on id

        | extend question = tostring(customDimensions['Question'])

        | extend answer = tostring(customDimensions['Answer'])

        |summarize NumberofTimesAsked = count(question) by question, answer

        | top 1 by NumberofTimesAsked desc

    Hope this helps you to explore Application Insights further more. Please reach out if you have other questions. 

    If this reply answers your question please "Mark as answered". Thank you


    Wednesday, January 9, 2019 10:30 PM
    Owner