Create a MTTR data visualization in Platform Analytics Workspace

Rakshanda Kunte
Tera Contributor

Hi All,

 

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

I tested this in lower environment and found the similar Indicator which has required conditions.

 

But, when I used that indicator in Workspace, it is not showing required output. 

 

Below is the Report created in Classic UI (Without Indicator).

RakshandaKunte_0-1705658029268.png

 

Graph looks like below (without Indicator)

RakshandaKunte_1-1705658152182.png

 

With Indicator:

This is the indicator source; I found and need to create above report in Platform analytics workspace.

RakshandaKunte_2-1705658750302.png

 

Can anyone please help how to create above report using this indicator source?

10 REPLIES 10

Hi @Rakshanda Kunte 

You need to execute the Historical Collection Job within the Automated Indicator. Then it will collect the scores for your Indicator. Once completion, your chart will display the score accordingly.

 

Cheers,

Tai Vu

Hi @Tai Vu ,

 

Thanks for your help throughout..

 

I have one more question. 

 

I have run the historical Job, but anyhow it is not giving the expected results. i.e. I need to see the duration on Y-axis.

 

Which configuration should I change to get the duration on Y-axis?

RakshandaKunte_0-1705991283821.png

 

 

Could you please help with this?

 

 

Thanks..

 

 

Hi @Rakshanda Kunte 

The Unit and Calculation is the Indicator-based configuration.

In your case, you can navigate to the automated indicator Number of new incidents.

If you'd like to calculate by Days

Screenshot 2024-01-23 at 13.55.33.png

 

And you may also need to convert the duration to days to be able to calculate the Average.

Timi_0-1705993016152.png

 

Cheers,

Tai Vu

Thanks @Tai Vu..

 

This helped to fetch the data.

I will need one more thing in this.

 

This only shows the days. I need Day:Hours:Minutes:seconds format.

 

Is it possible?

Hi @Rakshanda Kunte 

You may want to try the Time unit.

 

If you select Time as the unit, the time is given as Days, Hours, and Minutes. If the system property glide.ui.duration.seconds.enabled exists and is true, seconds are also displayed. In this case, seconds are also displayed for all time fields on the instance and are included in exports to Microsoft Excel.

 

Cheers,

Tai Vu