Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm having this Raw data of visits of objects per unique FaceID:
I made a calculation the sums up the total duration per each FaceID (max end time - min start time), this is the result:
My next goal is to find the average duration of the calculation I made in the right column.
I can present it in table (highlighted in red), but I want to take it into KPI/Different Chart as a measure.
Can you assist with the expression?
Thanks,
Eli.
try sthing like :
time(avg(aggr(YourIntervalCalculation,FACEID)),'hh:mm:ss')
Thanks for your response, I've tried your suggestion:
time(avg(aggr(Interval(Max([End Time]) - Min([Start Time])),FACEID)),'hh:mm:ss')
But got a wrong result:
Eli.
Maybe you should try to aggregate by all the dimensions in your table
Aggr(expression, dim1,dim2,dim3 etc)
I tried but still not getting the expected result as in the table's total.