Hi team
I need few reports (see the attached)
1. A NUMBER which shows Open Request and Incident
2. A NUMBER > Unassigned Request and Incident.
3. Average Age
Thank you
Hi @Navneet3 ,
Based on that you only should show RITMs, I would advise to create the report based on the sc_req_item table:
Based on that you would like to see data by month, you should chose a times series visualization:
For the requirement to see open and closed on one month, you need a report with two datasets:
one dataset with open and one dataset with closed. It will not be possible to see how many open and how many closed pr. month in a time series widget:
First dataset: trend by opened and per set to month:
Save and press
Chose "add dataset":
Configure the dataset as below:
Your visualization will then be:
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
Hi @Navneet3
For report 1 create a single score report through the report designer with below conditions:
For report 2, create a single score report through the report designer with below conditions:
For report 3, you need to utilize performance analytics, as you need a formula indicator to calculate the average age of above - this you can't do through the report designer.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
