Help reporting on KB Article Views

[Elizabeth Barlo]

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:

[James Chun]

Hey @Elizabeth Barlo,

Not sure if you can use a list type report here, have you considered using a different type such as bar graph?

Cheers

[Elizabeth Barlo]

@JAM - Is there any way to control the display for the columns or rows to show more text?   We would like to be able to include a screen shot of the report in a monthly email that highlights our Employee Portal usage, but the article names are truncated, which doesn't allow you to see what the top items are.

[Elizabeth Barlo]

Upper management asked to display the information in the list view, instead of the graph because you can't view the article names clearly in the graph format and we want to include a screen shot of the results in monthly updates to to the company.    

It really doesn't make any sense why the graph works properly, but the list does not.

[Tsura Andreeva]

what if you used the kb_use table and group on the article.short description