Skip to main content

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

Hi @eashwar11,

Since you reported this through Support as well and we’ve been handling the request from there, I’ll close this question here. 

Have a nice day!

Carin


@Carin Meems Can you post the solution for this under this item? Thank you so much!


Hi @rsiddha

 

We advised the user to get a sandbox environment, and then use Cognite Functions to fulfill his request. 

 

Best,

Carin


Reply