Hello All,
I am trying to show count of distinct bottom 20% codes in a KPI
same i have tried and succeed in combo chart but not able to show in KPI object
In Combo chart
Dimension : Code
Expression :
If(RangeSum(Above(Sum(d_OP),0,RowNo()))
<
(Sum(TOTAL d_OP)*20/100),sum(d_OP),0)
Expression %:
If(RangeSum(Above(Sum(d_OP),0,RowNo()))
<
(Sum(TOTAL d_OP)*20/100),(sum(d_OP)/sum(total d_OP))*100,0)
sorting : Code--->Expression:sum(d_OP) --->Ascending
But for KPI i am confuse how to write a expression which sort and get bottom 20 % codes count
Attaching the out put file of my Bottom 20 % Combo chart where distinct codes count is 535.
Need to show the same value in KPI
