I am having issues to calculate a metric concerning operators efficiency.
I have a table with those fields :
-TimeStamp (MM/DD/YY- HHMMSS)
I want to calculate the number of products scanned by operators / hour
I was assuming that the best way to do it was to calculate the difference between the first time stamp of the day made by an operator and the last one. Then to divide the quantity of products associated to this operator on this day by the difference just calculated.
Do you have any ideas about how could I do that?
I have joined my table if you want to have a look at it.
Thank you very much have a nice day