Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello partners!
Could someone help me with this calculation? I want to calculate the average travel time of a supplier from when he enters until he leaves a position, this supplier can enter several times a day and it is necessary to determine the time it takes him to be in each position.
My information has the following structure:
Thank you for your support!
Cheers,
DC
Check out this post I worte years ago about how to use the Qlik Script function called PREVIOUS that lets you see the previous row of data. Concept is sort the way you read the input data and then you can compare a value in the current row to the value in the previous row.