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
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])
i used this measure
Ahmedx's avatar
Ahmedx
Super User
2 years ago

why do you use conditional
AVERAGE(support__cw_ops_manage_case_merge_temp[Abandon %])
------------------
this is incorrect, needs to this
CF = SWITCH(TRUE(),
[Abandon %] <= 0.04,"#008000",
[Abandon %]<= 0.1 ,"#FFFF00",
"#FF0000"
)

  • saud968's avatar
    saud968
    Memorable Member
    2 years ago

     Because this column - support__cw_ops_manage_case_merge_temp[Abandon %] is not showing when only using switch. Also, I am trying to share the file as I have lower the file size as drive and other uploading sites are blocked and I have to email the file to myself and then upload and share

    • 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