I have a set of work orders with the following schema along with sample data for two assets (10010234, 10010235)
{Equipment Work Order # Order Type Start Date Start Time End Date End Time Cost}
| 10010234 | 110025063 | Unplanned | 7/6/2018 | 11:31:15 | 7/6/2018 | 23:00:00 | 35,600 |
| 10010234 | 110026082 | Planned | 8/25/2018 | 12:27:15 | 8/27/2018 | 23:44:00 | 37,180 |
| 10010234 | 110027101 | Unplanned | 12/8/2018 | 13:30:15 | 12/8/2018 | 17:00:00 | 26,580 |
| 10010234 | 110028120 | Unplanned | 1/27/2019 | 14:40:15 | 1/29/2019 | 1:45:00 | 38,900 |
| 10010235 | 110023050 | Planned | 3/1/2018 | 15:57:15 | 3/2/2018 | 3:02:00 | 25,000 |
| 10010235 | 110024617 | Planned | 6/14/2018 | 17:21:15 | 6/16/2018 | 4:30:00 | 30,000 |
| 10010235 | 110026184 | Planned | 9/27/2018 | 0:25:00 | 9/27/2018 | 6:09:00 | 24,600 |
| 10010235 | 110027751 | Unplanned | 1/10/2019 | 20:30:15 | 1/12/2019 | 7:59:00 | 35,600 |
Equipment is stored as assets and the work orders are stored as ‘Events’. Now, I would like to compute MTTR and MTBF from this data within CDF and make it available for maintenance team so that they can monitor and take timely actions.
Please advise on how to fulfil this objective in CDF