Calculating MTTR(Mean Time to Recovery)

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?

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 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
1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.