I was wondering if you had some suggestions on the easiest way to calculate the total number of hours a machine is operated per 24 hour period? The data that I have available is total machine operating hours, analogous to an odometer in a car. This odometer is being sampled periodically throughout the day so it seems I would need to take the first sample of the day and the last sample of the Day and calculate the difference. How can I accomplish that in a workflow?
I will want to be doing that for each device in our fleet (thousands) independently.