Filtering on knowledge article Views by date range
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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?
- Labels:
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
THANKS @mujeebqasimi but that created date is for when the view was created or when the article was created?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
when the view was created.
Mark my answer right if it helped and accept the solution :p.
