Knowledge use report to show by month

[Thereza Van der]

Good afternoon all 🙂

I have a report that shows all knowledge articles used but the user needs it to show by month. I tried a trend graph, but not sure which field to use to show by month? Used and viewed is a boolean field so how do I display by month?

The graph below is how it is currently setup (bar graph) and I am using the kb_use table. Any ideas would be appreciated.

Regards

Thereza

[Slava Savitsky · Accepted solution]

Indeed, you should be able to accomplish this with a trend report. Select the following values on the Configure tab:

Group by: --None--

Trend by: Created

Calendar: Standard calendar

per: Month

Aggregation: Count

[Thereza Van der]

Thanks, I got confused with the 'created' field, but it makes sense cause it is the kb_use table.

[Mark Manders]

You can use the 'created' field. The entry in the kb_use table is created on the use or view of the article. So if you watch it 4 times in one day, it gets 4 entries.