Forum Discussion
Measure to Divide by Day
I have a project that divides the amount of time a machine experiences an error multiplied by 100 all divided by the time that the machine runs. I'm trying to show this information by day rather than a grand total of time that it is running for all days together. I'm not sure how to do this.
2 Replies
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Please provide some dummy data and your expected result to make the requirement more clear.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Basically I have timeline data for machines that shows when the machine state changes and for how long. What I do is calculate the amount of times one of those states is categorized as "Minor Stops" and divide that by the total amount of time that the machine is categorized as running. Now I want to divide the number of Minor Stops by the amount of time the machine is running by day, not the total time selected. For example, I need it to divide the minor stops by day for a total week, not the total time of the week.
L04 Reason Running Running ######### ######### 00:57:03 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:15 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:10:46 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:21 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 01:39:12 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:59 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:16:02 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:19 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:18:30 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:17:36 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:13:14 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:17 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:01:16 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:16 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:06:52 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:00:16 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:14:35 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:06:03 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:11:09 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:04:54 [ L04 SBO 20 5254 ] PREFORM ENTRY STOP ON PCC BY OPERATOR Minor Stops L04 Reason Running Running ######### ######### 00:07:53 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:11:03 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:02:07 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:04:57 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 01:58:51 [ L04 SBO 20 5254 ] Running Running L04 Reason MinorStops Own ######### ######### 00:01:51 [ L04 SBO 20 5254 ] PRODUCTION NOT IN AUTO Minor Stops L04 Reason Cleaning PlannedDowntime ######### ######### 00:15:00 [ L04 SBO 20 5254 ] (CIL) Cleaning, Inspection, Lubrication Cleaning / Insp. Lubric L04 Reason Running Running ######### ######### 01:45:28 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:04:35 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 01:11:14 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:22:17 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:07:51 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:18:33 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:04:30 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:02:06 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:03:00 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:15:03 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:05:57 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:14:25 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:02:31 [ L04 SBO 20 5254 ] Running Running L04 Reason NoPlcCommunication Downstream ######### ######### 00:06:04 [ L04 SBO 20 5254 ] D/S: DISCHARGE BACKUP Machine Process Waiting L04 Reason Running Running ######### ######### 00:10:44 [ L04 SBO 20 5254 ] Running Running