I've the following data.
I need to count the Status for each block of IN and OUT, and find out the Max and Avg IN and OUT for each Car. Below is the example for Car 1. Each session is 0.5 day.
Is there anyway that i can count the status for each block in Qliksense?
Please help me as i cannot resolve this for a week already. Really appreciate the help or advise given.
Hi Kush, based on the status change, from IN to OUT or OUT to IN.
Based on the example, there are 3 blocks of IN and 3 blocks of OUT.
im looking at Rangesum, but not really sure how to use it. Especially when to stop the count and reset it to zero in order to start next block.
Check if this works -
Hi Neymar_Jr, thanks for the replied. The formula doesn’t work. The value will not be the expected result after first block. Please see the result below based on my example. (Sorry that I reply using my phone)
OUT-2 (from here onward the value is wrong)