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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-26-2018 07:29 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-27-2018 03:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-30-2024 10:46 AM
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.