Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

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.