Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Have 20 KPI Names . How can I combine all 20 KPI's and assign RAG colors with single expression . I have loaded KPI Names in Pivot table as Dimension.
For example you can take KPI names as Network, Mobile, Fixed and so on.....
Can someone help?
Probably with a pick-match combination
pick(match(MyKPIDimension, 'Network', 'Mobile', 'Fixed', ... and so on ....)
, If( sum(Something) < 10, Red(), if(sum(Something) < 20, RGB(255,128,0), Green()))
, If( sum(SomethingElse) < 25, Red(), if(sum(SomethingElse) < 50, RGB(255,128,0), Green()))
, If( sum(SomethingFixed) < 4 , Red(), if(sum(SomethingFixed) < 8, RGB(255,128,0), Green()))
, ... and so on
)