How to create a report on top x records in servicenow?

[Chitra23]

Hi,

I have a requirement to create a report on top x  reports that takes longer to load.  I have created a report on report_stats table and added the filter condition "last run on last week" and sort by "average execution time" descending . It is giving me more than 50 records.

Is it possible to limit the number of records in the report?

How do I display only top 10 records?  Thanks in advance.

[Runjay Patel · Accepted solution]

Hi @Chitra23 ,

If you are displaying the report in bars then you can control like below.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Chitra23]

Hi @Runjay Patel , Thanks for your solution.  I was able to filter the records based on the number of groups. Apologies for the late response