topic MTTR and MTTI Calculations in Open Q&A

MTTR and MTTI Calculations

echwallah — Tue, 22 Nov 2022 15:54:17 GMT

Has someone been able to identify a metric using available list of problems and their start and End times to create a Metric for MTTI and MTTR.

These are key performance indicators for some of our clients and it would be great if Dynatrace can provide OOTB for such metrics and ability to segment by Application, Problem type, Management one et cetera.

I believe since problems have metadata as Start Time and End-time, a simple aggregation of the summating of the difference between start and end time based on a particular time period and divided by number of Problems within the same period would be MTTR as the Quotient. Unfortunately Metrics Explorer only has List of Problems and no Start and End times to achieve this.

Let me know if someone has been able to accomplish this and if Dynatrace is looking at providing this OOTB

Re: MTTR and MTTI Calculations

Mizső — Tue, 22 Nov 2022 15:11:31 GMT

Hi @echwallah,

I think there is not OOTB solution for your request. You have to make calculations based on Problem APIv2 data. We do this at our customers in PowerBI. If you want you can send back these information to DT as a custom metric.

I hope it helps.

Best regards,

Mizső

Re: MTTR and MTTI Calculations

echwallah — Tue, 22 Nov 2022 15:19:53 GMT

Thanks for this @Mizső Am not familiar extensively with PowerBI and the API calls..Just worked on very simple ones.

Could you possibly share to me the Queries you are using to pull this and generate this view that I can adapt to the environment using PowerBI. I know this is a huge ask but this would help greatly n initiating the discussion on capability with the client..

Am sure it will be just a matter of changing the Environment URL and the Access Token with the right scope

My email echwallah@ncgafrica.com

Re: MTTR and MTTI Calculations

AntonioSousa — Tue, 22 Nov 2022 19:25:24 GMT

WoW! This is quite an integration!

Re: MTTR and MTTI Calculations

echwallah — Tue, 22 Nov 2022 19:30:57 GMT

In theory I still think this does not require a third party platform like PowerBI. Dynatrace has Start times and End Times of all detected problems and related MetaData. MTTD and MTTR are metrics that can be constructed from Data Explorer filtering by different dimensions

Re: MTTR and MTTI Calculations

Mizső — Tue, 22 Nov 2022 19:31:14 GMT

Hi @AntonioSousa,

It was the base and we have modified it with other functions.

https://www.youtube.com/watch?v=PNX0jCL8AHc

Mizső