Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Filtering on knowledge article Views by date range

Casey4
Tera Contributor

We have a report on knowledge article views but is there a way to filter by date range or date on when the views were created: OOB, its for all time and its not really useful. 

So how do we filter on views of knowledge articles by date?

4 REPLIES 4

mujeebqasimi
Kilo Guru

The OOB “View count” field can’t be filtered by date because it’s just a total.

To report on views by date, create a report on the Knowledge Use [kb_use] table instead. Filter on Viewed = true and add a condition on Created (e.g., Last 30 days or a specific date range). Then group by Article and use Count aggregation.
solution1.jpg

THANKS  @mujeebqasimi   but that created date is for when the view was created or  when the article was created?

It is first part.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

when the view was created. 
Mark my answer right if it helped and accept the solution :p.