How can i pull a report showing how many times a knowledge article has been rated?

[Andrei4]

Hello ServiceNow experts,

I`m trying to figure out how many times a knowledge article posted in a customer facing knowledge base has been rated. While i do see the number of views and the actual rating, it`s of no use for me unless i find out how many people rated that article and even when it was last rated.

Any ideas? It would like to have this on the knowledge management dashboard so it would need to be refreshing itself on a regular basis.

[Waleska · Accepted solution]

You could make a report off the kb_feedback table and set the condition to be "Rating is not empty". You can then choose however you want to view it but you can use a list view and group by Article number or you can create a bar chart etc, whatever you want for the data you want to see.

Let me know if you have any questions!

[Andrei4]

This i extracted already but i`m not finding a way of displaying how the rating was obtained. I need to check how many times the rating was given but i have no idea what column would that be. Here's how it looks like: (I would need something like "number of times rating was submitted)

[Waleska]

This is where I'd recommend you use the group by Article option under the configure step. You can even potentially use a stacked bar. Group by article then have the stacks represent the rating given. That way you can see the ratio per article.

[Andrei4]

Ah ok perfect. So it means the below would have been rated 35 times correct?