The Zurich release has arrived! Interested in new features and functionalities? Click here for more

How to limit number of results in a report (list format) using GUI? Suppose I need only the top 10 oldest incidents. How can I achieve this?

Mitesh Agrawal
Kilo Contributor

How to limit number of results in a report (list format) using GUI? Suppose I need only the top 10 oldest incidents. How can I achieve this?

2 REPLIES 2

Carl Fransen1
Kilo Sage

Hi

Have you tried what's in this post?  Or there are some good options here or here as well.

 

Hop this helps

Carl.

Christine Mayf2
Tera Contributor

I wanted to achieve the same, but I needed a report to show the top ten list of records (based on a 'percentage' field in the records), so I added a new true/false 'Top 10'  field to the record, readonly, default is 'false.' I created a scheduled job to nightly sort all the records in descending order based on the 'percentage' and then iterate through, setting the first 10 records 'Top 10' value to true and setting all the rest to false. Not a real time report, but for top 10, this fit the bill for me. Besides, you could always drill down into the report and go to the list, sort by 'percentage' and easily see real time data if needed.