Limit the bars of column trend chart

[Venkat122]

Hi All, 

I am reporting on sp_log table to find the most searched keyword. Howver, I want to show trend chart so that we can find the popular search words by month but I wanted to show only top 10 in each month. I could not find any option to acheive this, please guide/help me on this.

[Adam Stout]

Have you looked if text analytics will work here?  https://docs.servicenow.com/csh?version=latest&topicname=text-analytics-widgets

[Venkat122]

Yes, that's a great feature. However, in current project we didn't purchase Performance analytics. Hence, trying with the reporting functionalities. Please guide me if there is any way to achieve the requirement.

Requirement: Show the top 10 search terms for each month

[Adam Stout]

Text Analytics would be my preferred option but if I had to do it in reports, I would create a dynamic filter to find the top words per month, then your report could just show them.  It would require (at least) a double pass of the data but it should be possible.

https://docs.servicenow.com/csh?version=latest&topicname=t_ScriptedFilters

https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e