MTTR Report using Performance Analytics Indicator

[Rakshanda Kunte]

Hi All,

I have requirement where, we need to show report for MTTR using incident table. 

I created the report in Classic UI so, below is the one. 

But, when I created using indicator, it did not give expected results.

Report in Classic UI:

Filter Conditions:

Graph Looks like this.

Graph using Indicator:

Source and additional conditions:

But the graph looks as below:

The time ranges are totally different, even if it is average. 

Can you please help to identify where I am going wrong?

Let me know, if any additional information is required.

Thanks..

[AndersBGS]

Hi @Rakshanda Kunte ,

Do you have any formula indicator associated with above? I noticed that you have a sum of duration, but you're not aggregating to average as in the report? 

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

Best regards

Anders 

[Rakshanda Kunte]

Hi @AndersBGS,

Formula indicators are using 'Incident_metric' table. But customer wants to create this report using 'Incident' table. Hence, I have created new indicator for this using incident table. 

I modified the indicator to make it 'Average' still not getting desired output.

Indicator: 

Result in Analytics Hub:

Report results in Classic UI (Required Output): 

Is there any way to modify this?

Thanks.

[AndersBGS]

Hi @Rakshanda Kunte, 

Haven't seen the error yet, but I do believe that it is something with the calculation.

In the report you have a max of 7 days, but in PA you're up to 405 days, so something is calculated differently. 

In general, I would have created one automated indicator for count of incidents and one automated indicator for sum of duration. Afterwards I would have created a formula indicator to do the calculation "(sum of duration / count of incidents)"

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

Best regards

Anders