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

This is a really old video: is there an update: it from Kingston I believe: and we are in Yokohama now

Hi @Kass3m 
Sure, I will send you step-by-step details on how to build it... Will get back soon.

thanks - also are we able to add a date filter to this word cloud?