How to display the latest records in a report

[ayano]

I am creating a report for incident.

Is it possible to extract and display one of the latest records in each subcategory?

[msnowr]

How did you solve this? Could you please update the solution?

[Riya Verma]

Hi @ayano ,

Hope you are doing great.

To display the latest records in a report for incidents, you can follow these steps:

1. Start by creating a new report for incidents in ServiceNow.

2. Set up filters to specify the criteria for the incidents you want to include in the report. For example, you can filter by subcategory or any other relevant field.

3. o display the latest records, make sure to sort the report results by the date field in descending order. This way, the most recent incidents will appear at the top of the report.

4. Depending on the number of records you want to display, you can set a limit on the number of results in your report. For example, if you want to display only one of the latest records in each subcategory, you can set the limit to 1.

5. Save the report configuration and preview the report to ensure it displays the latest records as per your criteria.

[PJ363182]

Can you please explain more on #4. Where do I set the limit?

[msnowr]

Hi @Riya Verma I have a report that shows the records grouped by the application name. I would like to show only the latest record for each application. for example, I would like to see only the record marked in red, for that app. How do we achieve this?

[User205031]

Hi @msnowr , Did you manage to achieve this?