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:
- Group by Terms of ID
- For each ID, group by Terms of status
- 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.