Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Location Capacity
GA 20
CA 10
Month ID Location
1/1/2016 1 GA
1/2/2016 1 GA
1/3/2016 1 GA
1/3/2016 2 CA
1/4/2016 2 CA
1/5/2016 2 CA
Utilization = (count(distinct([ID])) /sum(Capacity)
How to calculate the average instead of total in the above calc...
Try like this
Count(distinct ID)/sum(Capacity)
Avg(count(distinct([ID])) /sum(Capacity)
use following :-
Avg(count(distinct([ID]) /sum(Capacity))
Thanks,
You can't nest aggregation functions like that. You probably need something like
Avg(Aggr(Count(Distinct ID]) / Sum(Capacity), Location))