# Calculate MTBF/MTTF Mean time between/to failure for a visualization

**URL:** <https://discuss.elastic.co/t/calculate-mtbf-mttf-mean-time-between-to-failure-for-a-visualization/134995>\
**Category:** Kibana\
**Created:** [June 7, 2018, 1:13pm UTC](https://discuss.elastic.co/t/calculate-mtbf-mttf-mean-time-between-to-failure-for-a-visualization/134995 "2018-06-07T13:13:11Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![topel](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@topel](https://discuss.elastic.co/u/topel)\
**Post date:** [June 8, 2018, 8:22am UTC](https://discuss.elastic.co/t/calculate-mtbf-mttf-mean-time-between-to-failure-for-a-visualization/134995/3 "2018-06-08T08:22:26Z")

</div>

Hi @chrisronline,

I just double checked the issue was [this one](https://discuss.elastic.co/t/kibana-how-to-calculate-a-delta-metric-in-table-visualization/73646/4) and I seem to have recollected it wrong - it only vaguely touches the topic.

Sample job data:

> **ES job index entry**
>
> ```
> {
> "_index": "test-jobs-old",
> "_type": "doc",
> "_id": "yL_j1WMBkhQDVC7mqY67",
> "_score": 1,
> "_source": {
> "displayName": "GroovyTester_Pipeline",
> "@timestamp": "2018-06-06T16:17:25.649Z",
> "description": "",
> "lastSuccessfulBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/23/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 23
> },
> "firstBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/1/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 1
> },
> "concurrentBuild": true,
> "resumeBlocked": false,
> "keepDependencies": false,
> "beat": {
> "name": "dashboard",
> "hostname": "dashboard",
> "version": "6.2.4"
> },
> "healthReport": {
> "buildStability": {
> "remark": "4 out of the last 5 builds failed.",
> "score": 20
> }
> },
> "fullName": "GroovyTester_Pipeline",
> "nextBuildNumber": 24,
> "inQueue": false,
> "parameterDefinitions": {},
> "url": "https://bla.com/job/GroovyTester_Pipeline/",
> "lastStableBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/23/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 23
> },
> "fullDisplayName": "GroovyTester_Pipeline",
> "lastUnsuccessfulBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/22/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 22
> },
> "name": "GroovyTester_Pipeline",
> "lastCompletedBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/23/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 23
> },
> "host": "dashboard",
> "buildable": true,
> "offset": 1394532,
> "prospector": {
> "type": "log"
> },
> "color": "blue",
> "actions": [
> "hudson.plugins.jobConfigHistory.JobConfigHistoryProjectAction",
> "com.cloudbees.plugins.credentials.ViewCredentialsAction",
> "hudson.plugins.buildblocker.BuildBlockerProperty",
> "com.sonyericsson.rebuild.RebuildSettings",
> "com.synopsys.arc.jenkinsci.plugins.jobrestrictions.jobs.JobRestrictionProperty",
> "org.jenkinsci.plugins.workflow.job.properties.PipelineTriggersJobProperty"
> ],
> "lastFailedBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/22/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 22
> },
> "tags": [
> "json",
> "jenkins",
> "jobs",
> "init",
> "beats_input_raw_event"
> ],
> "builds": [
> "https://bla.com/job/GroovyTester_Pipeline/23/",
> "https://bla.com/job/GroovyTester_Pipeline/22/",
> "https://bla.com/job/GroovyTester_Pipeline/21/",
> "https://bla.com/job/GroovyTester_Pipeline/20/",
> "https://bla.com/job/GroovyTester_Pipeline/19/",
> "https://bla.com/job/GroovyTester_Pipeline/18/",
> "https://bla.com/job/GroovyTester_Pipeline/17/",
> "https://bla.com/job/GroovyTester_Pipeline/16/",
> "https://bla.com/job/GroovyTester_Pipeline/15/",
> "https://bla.com/job/GroovyTester_Pipeline/14/",
> "https://bla.com/job/GroovyTester_Pipeline/13/",
> "https://bla.com/job/GroovyTester_Pipeline/12/",
> "https://bla.com/job/GroovyTester_Pipeline/11/",
> "https://bla.com/job/GroovyTester_Pipeline/10/",
> "https://bla.com/job/GroovyTester_Pipeline/9/",
> "https://bla.com/job/GroovyTester_Pipeline/8/",
> "https://bla.com/job/GroovyTester_Pipeline/7/",
> "https://bla.com/job/GroovyTester_Pipeline/6/",
> "https://bla.com/job/GroovyTester_Pipeline/5/",
> "https://bla.com/job/GroovyTester_Pipeline/4/",
> "https://bla.com/job/GroovyTester_Pipeline/3/",
> "https://bla.com/job/GroovyTester_Pipeline/2/",
> "https://bla.com/job/GroovyTester_Pipeline/1/"
> ],
> "lastBuild": {
> "url": "https://bla.com/job/GroovyTester_Pipeline/23/",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowRun",
> "number": 23
> },
> "source": "/srv/jenkins_data/init_jobs_log_2018-06-06_163617.json",
> "@version": "1",
> "class": "org.jenkinsci.plugins.workflow.job.WorkflowJob",
> "property": []
> }
> }
> 
> ```

---

_[View the full topic](https://discuss.elastic.co/t/calculate-mtbf-mttf-mean-time-between-to-failure-for-a-visualization/134995)._