Hi,
I wrote two versions of Avg duration calculation and I want to understand which one is better in terms of performance:
Version 1:
interval(Avg(aggr(sum({<[Class Category ID]={0}>} Duration),ObjectID)))
Version 2:
interval(sum({<[Class Category ID]={0}>} Duration) / count({<[Class Category ID]={0}>} ObjectID))
ObjectID is unique value (No duplicate values)
Thanks,
Eli.