I am trying to run a report that shows the total number of views for each KB article so we can determine which articles are the most used.
The issue I'm having is that each version of the article shows up as a different line item, even if I'm using Number for the grouping. This results in two totals for the same article (and in some cases 4 lines for one article.)
Table being used: kb_knowledge
Screen shot of results:
Hi @Elizabeth Barlo,
How does the below work for you based on your comments and feedback.
Similar to what @Tsura Andreeva advised by leveraging the 'kb_use' table however additionally leveraging and Group By the 'Summary' field which is an Out Of Box field that captures the KB Article number without the version.
See the below screenshot.
To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.
Thanks, Robbie
You can modify the filter to include Latest is true
I have the same request from my management. A report on which articles are being viewed in a descending order.
I've setup the report on the kb_use table as a list report. I've set the group by as Article > View count. I've tried a few different things under Additional group by but the report seems to ignore those. I've tried Article Summary, Article Summary > Number, and Article > View count.
I've also added the filter from @Shawn34 to use Article>Latest Is True.
I'm stumped, no matter what I try I always get these never changing results
What I'd like to see is the article number, short description and view count where the view count is descending from highest to lowest view.
