Hello, we run a manufacturing operation with 18 laser cutters. Our goal is to log their run time and idle time so that we can report on the efficiency of the production staff across certain days, shifts, weeks, etc.
I've created a device that detects when the machine starts or stops, and calls a Restlet to update an ASSET record in Netsuite. The asset record tracks the current state of the machine, as well as the date/time that the state changed. We're using this data for digital signage to show the current status of the machines.
Right now there is only the System Information log that tracks when field values change. So technically we have a history of every time its run_state changes from running to idle and back. But this log is probably not the most ideal for reporting.
Is there a recommended strategy for logging data like this in a way that it can be reported on easily? I have tried to imagine if we should write a record per machine every time it goes idle, with the time that it ran? But this can happen across hourly boundaries. For example, the machine could start at 7:55 and run 30 minutes. So if you're trying to report on the efficiency of a machine between 7:00 and 7:59, you could only count 4-5 minutes of that record towards that hourly slot. This is where I'm drawing a blank on the best way to log this data so we can break it up in different ways.