Measurement of efficiency per Day

[#1]

Hello everyone,

I am having issues to calculate a metric concerning operators efficiency.
I have a table with those fields :

- User

-Date

-Quantity

-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

Alexandre BERNARD

[jonathandienst]

Something like this:

Data:

LOAD

  User,

  Date,

  Quantity,

  TimeStamp

FROM ....;

Join (Data)

LOAD User,

  Date,

  Min(TimeStamp) As StartTime,

  Max(TimeStamp) As FinishTime,

Resident Data

Group By User, Date;

Final:

LOAD

  User,

  Date,

  Quantity,

  StartTime,

  FinishTime,

  Quantity / ((FinishTime - StartTime) * 24) As ScansPerHour

Resident Data;

DROP Table Data;

[#3]

Hi John,

Thx you very much for answering.

I have tried your formula but it does not seem to work unfortunately.

Would you know any set analysis formula that would enable me to re-create the order by statement so that i can select day and user in my table ?