Getting Average Duration on Incidents by month

[D-a-n_L]

How do I get the average duration it took to open and resolve an all incidents by month?

Can I do this in any repeatable report?

[Robert H · Accepted solution]

Hello @D-a-n_L ,

Looking at your last screen shot, all you need to do is select "Trend by" to "Created", then "Per" to "Month", and "Aggregation" to "Average". This will make one more field appear where you need to select "Duration".

Basically the four fields that I had highlighted in red boxes in my original response.

Regards,

Robert

[D-a-n_L]

Your instructions outlined the fields you mentioned are not available for selection.

3. **Configure Data for the Report**:

   - Choose the **Incident** (or relevant) table as the source for the report.

   - Select the fields to display (e.g., `Duration`, `Opened By`, `Created On`, etc.).

[Shivalika]

Hello @D-a-n_L 

These are the columns of incident table which you want to show in report and why they are not available, it's because the TYPE of this REPORT is TIME SERIES. Otherwise in general reports - like list type - there is option to choose fields. 

So you can proceed with step 4,5,6 post this 🙂

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Robert H · Accepted solution]

Hello @D-a-n_L ,

Looking at your last screen shot, all you need to do is select "Trend by" to "Created", then "Per" to "Month", and "Aggregation" to "Average". This will make one more field appear where you need to select "Duration".

Basically the four fields that I had highlighted in red boxes in my original response.

Regards,

Robert

[D-a-n_L]

I got it. That was tough but you stuck it out with me and that was the reason I have the report I need now. Thank you.

[Shivalika · Accepted solution]

Hello @D-a-n_L 

We can now accept multiple posts as solutions. So kindly accept my solution as well if it helped you in anyway. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY