Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to create a Word Cloud Dashboard from ts_query_kb table ?

AbdurRahmanSnow
Giga Guru

Good evening.
I have a requirement to create a dashboard. The dashboard will be on Knowledge Searches ( ts_query_kb ) table, which captures all the most searched words on Service Portal, short description, everywhere, along with the repeat count. Screenshot below.
So, in the search bar below, if you type any word, it will show the word along with how many times, it got repeated... Meaning, the word will come on dashboard and when we hover on the dashboard, it will show more details. The data shown should be monthly. You can see below (16k searches made it Aug 2024)
Please help. This is a very unique requirement. 

AbdurRahmanSnow_0-1740489797457.pngBelow is how the report  data will have on different tables,.... just an example/reference... please neglect.

AbdurRahmanSnow_1-1740489994388.png

This is how Knowledge Searches table will capture all the most searched-words.

AbdurRahmanSnow_3-1740490776844.png

 

 

1 ACCEPTED SOLUTION
5 REPLIES 5

@AbdurRahmanSnow  When can you send this?

also, see my question about the date filter?