Avg duration per Unique ID

[EliGohar]

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.

[OmarBenSalem]

try sthing like :

time(avg(aggr(YourIntervalCalculation,FACEID)),'hh:mm:ss')

[EliGohar]

@OmarBenSalem 

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.

[OmarBenSalem]

Maybe you should try to aggregate by all the dimensions in your table 

Aggr(expression, dim1,dim2,dim3 etc)

[EliGohar]

I tried but still not getting the expected result as in the table's total.