# Calculating MTTR(Mean Time to Recovery)
**URL:** https://discuss.elastic.co/t/calculating-mttr-mean-time-to-recovery/255741
**Category:** Kibana
**Created:** [November 17, 2020, 5:43pm UTC](https://discuss.elastic.co/t/calculating-mttr-mean-time-to-recovery/255741 "2020-11-17T17:43:03Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@sam7](https://discuss.elastic.co/u/sam7)
#### Post date: [November 17, 2020, 5:43pm UTC](https://discuss.elastic.co/t/calculating-mttr-mean-time-to-recovery/255741/1 "2020-11-17T17:43:03Z")
I have an Index having build failed and succeeded status with respective time stamp. I want to calculate MTTR(Mean Time to Recovery) using scripted field or any other option available. Any suggestions?
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [November 19, 2020, 7:13pm UTC](https://discuss.elastic.co/t/calculating-mttr-mean-time-to-recovery/255741/2 "2020-11-19T19:13:06Z")
If this information is stored in a single document, you can create a Painless scripted field to calculate it.
If the information is stored across multiple documents, you will probably have some kind of ID field? If so, you can run a [transform operation](https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html) which can be set up like this:
1. Group by Terms of ID
2. For each ID, group by Terms of status
3. You can add two calculated fields, one to indicate the final status, and another to indicate the time to recover
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 17, 2020, 7:13pm UTC](https://discuss.elastic.co/t/calculating-mttr-mean-time-to-recovery/255741/3 "2020-12-17T19:13:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.