Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to calculate the 5 percentile in a calculation as per below:
Fractile({<[Site]=>} Total
aggr(
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)
My issue is that it works as it should till I filter then it recalculates the percentile for the row that has been filter, I'm filtering by Site, any help will be more than welcome.
Hi,
I just fixed adding {<[Site]=>} after the aggr
Fractile({<[Site]=>} Total
aggr({<[Site]=>}
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)
Perhaps this?
Fractile({<[Site]=>} Total
aggr(
(Max({<[Site]=>} DATA_VOLUME)/3600/1024+Max{<[Site]=>} DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max({<[Site]=>} aggr(Sum({<[Site]=>} Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)
Hi,
I just fixed adding {<[Site]=>} after the aggr
Fractile({<[Site]=>} Total
aggr({<[Site]=>}
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)