How to pull report from table

[Naga13]

Hi All,

Any one help on the below.

I want to pull the reports for each requirement (like with 3 conditions in one report)  separately.

Requirement - 1

Incidents created daily (Region wise)

Incidents Resolved Daily

Total outstanding Incidents (status - Assigned, In-progress, pending)

Requirement - 2

Ageing Incidents (Region Wise)

Total pending incidents with age range below

0-2 Days

3 - 5 Days

6 - 10 Days

10 - 15 Days

15 - 30 Days

> 30 Days

Regards,

Naga.

[AndersBGS · Accepted solution]

Hi @Naga13 ,

For your requirement 1, you need to create report in report designer  where "Incidents created daily (Region wise)" 
based on the incident table, and afterwards add datasets for the last two "Incidents Resolved Daily" and "Total outstanding Incidents (status - Assigned, In-progress, pending)": https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/reporting/task/t_AddAnAdditi...

For your requirement 2, you need to create a report range with the specific interval: https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/reporting/concept/c_ReportRa...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Naga13]

Hi AndersBGS,

Thanks for the inputs.

Best Regards,

Naga.