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

Chitra23
Tera Contributor

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.

1 ACCEPTED SOLUTION

Runjay Patel
Giga Sage

Hi @Chitra23 ,

 

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

RunjayPatel_0-1732000793248.png

 

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

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

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

 

View solution in original post

2 REPLIES 2

Runjay Patel
Giga Sage

Hi @Chitra23 ,

 

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

RunjayPatel_0-1732000793248.png

 

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

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
Tera Contributor

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