Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
I need to use expression as below to show
Pie Chart of percentage breakdown to Alarmed Cells, Highly Utilized Cells, Standard Cells and Low Utilized cells based on filtered KPI and date.
:
=if(Above($(vkpivalue))>4 and Above($(vkpivalue),0)>4,'Alarmed', if(-rangesum(($(vkpivalue)>4),(Above($(vkpivalue),1)>4),(Above($(vkpivalue),2)>4),(Above($(vkpivalue),3)>4),(Above($(vkpivalue),4)>4),(Above($(vkpivalue),5)>4),(Above($(vkpivalue),6)>4))>=4,'Highly utilized', if(-rangesum(($(vkpivalue)<3),(Above($(vkpivalue),1)<3),(Above($(vkpivalue),2)<3),(Above($(vkpivalue),3)<3),(Above($(vkpivalue),4)<3),(Above($(vkpivalue),5)<3),(Above($(vkpivalue),6)<3))>=6,'Low utilized', 'Standard')))
For example the straight table Classification output is showing "CELL C1 ->KPI->K1-->date->16/08/2015--as ""HIGHLY UTILIZED"".
Pie chart output should show the classification of CELLS per KPI and date in percentage i"e 100% HIGHLY UTILIZED FOR date ->16/08/2015.
How can I use the above expression for Pie chart calculation percentage.
Please suggest.
PFA the sampel qvw I am woring on.