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

Ahmedx's avatar
Ahmedx
Super User
2 years ago

try this

CF = SWITCH( TRUE(),
    MAX(support__cw_ops_manage_case_merge_temp[Abandon %]) <= 0.04,"#008000",
    MAX(support__cw_ops_manage_case_merge_temp[Abandon %])<= 0.1 ,"#FFFF00",
    "#FF0000"
      )
saud968's avatar
saud968
Memorable Member
2 years ago

I tried this 

CF = SWITCH( TRUE(), MAX(support__cw_ops_manage_case_merge_temp[Abandon %]) <= 0.04,"#008000", MAX(support__cw_ops_manage_case_merge_temp[Abandon %])<= 0.1 ,"#FFFF00", "#FF0000" )
it turned everything in red

the other 

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")
It is not able to find the  support__cw_ops_manage_case_merge_temp[Total_Chat_Count] / support__cw_ops_manage_case_merge_temp[ABANDONED_CHAT_FLAG]) columns weird 

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    pls share the file