Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have requirement in multi KPI on the conditional colours for Dimension and measure .
Below are the current Multi KPI and Expected Multi KPI.
I have also attached QVF.
Thank you!
Since that is limitation in Multi KPI, I would suggest to use pivot table and make it work. Attached the version with pivot table.
@Purushothaman Can you please share logic of Why Green (6), red (4), yellow (2) ...
Hi @Anil_Babu_Samineni ,
Below is the dataset. Its of count of ID with Dimension of Status.
Status | ID |
Red | AD1 |
Red | AD2 |
Green | AD3 |
Green | AD4 |
Red | AD5 |
Yellow | AD6 |
Yellow | AD7 |
Red | AD8 |
Green | AD9 |
Green | AD10 |
Green | AD11 |
Green | AD12 |
Thank you!
@Purushothaman It means you want to arrange a color based on Status?
HI @Anil_Babu_Samineni ,
Yes you are right.
Thank you!
Hi @Purushothaman ,
You will have to apply CSS in the multi KPI to get your desired O/P. Or alternatively, You can show it in a Pivot Table & Colour by Dimension.
Regards,
Rohan.
Hi @Rohan ,
Based on my requirement, could you able to suggest some code?
Thank you
Since that is limitation in Multi KPI, I would suggest to use pivot table and make it work. Attached the version with pivot table.