Report Open Request and Incident

[Navneet3]

 

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

[AndersBGS]

Hi @Navneet3 ,

Please explain further - what do you mean by it doesn't give you the result? is it because 2023 and 2024 is empty? if yes, then you need to create the trend by to created instead. 

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

Best regards

Anders 

[Navneet3]

Hi

Here is what the results should be?

All open and closed Request for a specific group in ONE graph.

[AndersBGS]

Hi @Navneet3 ,

Ok, you state all open and closed in one graph. Do you mean all open by day/week/month, and all closed by day, week, month? Should the two numbers be shown as single scores or what do you prefer? You mentioned all requests - do you only mean request from sc_req_item table or do you mean something else? 

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

Best regards

Anders 

[Navneet3]

Hi

I want OPEN and CLOSEDRITMs showing in one graph by months please.

Thank you

Navneet

[AndersBGS · Accepted solution]

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 pressin right top corner:

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