Create Report on Age of Task such as Current date - Created date

[Piyush Dwivedi]

Create Report on Age of Task such as Current date - Created date

[PratikshaKate]

@Piyush Dwivedi navigate to report designer and create new and follow the steps below:

1.Give your report a name 

2.choose a table. in your case I guess it is "Task"

3.click next

4.Provide the report criteria. in which you have to select the type of report for example : Bar, List

5.For an aging report, you'll typically use the "Created" field as the grouping basis. 

6.Then configure the report fields:

group by: Select the "Created" field. 

Group into Bins: This allows you to create custom age ranges (e.g., 0-1 day, 2-3 days, etc.). 

Treat date as age: This converts the "Created" date to a duration, showing how long the task has been open. 

7. Customize the report with visualizations like charts or graphs for better understanding

8.save and share

[Piyush Dwivedi]

@PratikshaKate Thanks for quick response, what you mean by:-

Group into Bins: This allows you to create custom age ranges (e.g., 0-1 day, 2-3 days, etc.). 

Treat date as age: This converts the "Created" date to a duration, showing how long the task has been open. 

[PratikshaKate]

@Piyush Dwivedi  There is OOB report range. search for it in navigator and create a range for your table for which you are creating a report, and this range will be available in group by option in your report. You can add that range.

Let me know if you are able to find it.

Please mark my answer helpful if it helped you.

[AndersBGS]

Hi @Piyush Dwivedi ,

What you're looking for is report ranges. https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_Report...