Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Issue with distinct count in kb_use

StianH
Tera Contributor

Hi, I'm im trying to work out a visual showing distinct article counts from kb_use. When comparing numbers between kb_use (distinct count) and the view count from kb_knowledge (knowledge_article.sys_view_count), the distinct count from kb_use shows fewer articles than the ones listed in kb_knowledge. 

 

I've taken out a small sample and identified some of the articles that do not show up in kb_use (distinct count) to see if the articles gets listed in KB_use at all. And they do. This leads me to think there is a more general issue with the distinct count metric than my tables and filters. 

1 REPLY 1

StianH
Tera Contributor

Update to post:

We've found that articles which has'nt been viewved in a while is not showing in the kb_use (distinct count). I would think this might have to do with the "glide.knowman.view_age.days" and  the "Count Knowledge Use" scheduled job, but my system administrator cant find these settings in our system. 

 

Knowledge View Count Does Not Match KB_Use - Support and Troubleshooting