Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Generate report showing unique article views

Keszia
Giga Guru

I have a report that shows the total number of views per month for the year, but they count all views and not unique per user. 

Keszia_0-1699303150103.png

I'd like to see the number of unique views we have to get a better reflection of traffic. If I open the report and group by user, I get a better reflection of how many people are looking at articles. For the month of October, I get 1,612 in this, but in the above it shows as 7,444. 

Keszia_1-1699303227649.png

Keszia_2-1699303286827.png

The problem is that if I try to edit the report to group by user, it gives an error message. 

Keszia_3-1699303377918.png

What can I do here?

5 REPLIES 5

Hey @PAWANK, are you using the kb_use table?

This is how mine's configured:

Keszia_0-1705265951518.png

Keszia_1-1705265982980.png