Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Conditional Formatting in matrix visual

Conditional formatting for an average of % in the matrix visual is not working... 0-4% should be green 5-10% in yellow and 11% above in red. You can review the screenshot below Abandon %...
Need Help
Show and Tell
Tips and Tricks
  • saud968's avatar
    saud968
    2 years ago

    Never Mind I was able to fix it, I changed the value a decimal number and found that in the rules i should use 0.04 and further so once it was fixed I changed it back % and it is working fine. Thank you for all your help

saud968's avatar
saud968
Memorable Member
2 years ago

I tried both but everything is going green

this does not show the calculated column so not working

CF = SWITCH( TRUE(),
    [Abandon %] <= 0.04,"#008000",
    [Abandon %]<= 0.1 ,"#FFFF00",
    "#FF0000"
      )




This is turning everything in green

ColorCategory =
VAR AbandonPercentage = AVERAGE(support__cw_ops_manage_case_merge_temp[Abandon %])
RETURN
    SWITCH(
        TRUE(),
        AbandonPercentage >= 0 && AbandonPercentage <= 0.4, "Green",
        AbandonPercentage > 0.4 && AbandonPercentage <= 0.1, "Yellow",
        AbandonPercentage > 0.1, "Red",
        BLANK()  
    )

 

Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

CF =
VAR _Abandon = 
IF(support__cw_ops_manage_case_merge_temp[ABANDONED_CHAT_FLAG] = 0, 0, support__cw_ops_manage_case_merge_temp[Total_Chat_Count] / support__cw_ops_manage_case_merge_temp[ABANDONED_CHAT_FLAG])
RETURN
SWITCH(TRUE(),
_Abandon <= 0.04,"#008000",
_Abandon <= 0.1 ,"#FFFF00",
"#FF0000")