Forum Discussion
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 %...
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
you need to crate measure
CF = SWITCH( TRUE(),
[Abandon %] <= 0.04,"#008000",
[Abandon %]<= 0.1 ,"#FFFF00",
"#FF0000"
)
and then follow the pictures
I tried this and followed the screenshot given by you
ColorCategory =
VAR AbandonPercentage = AVERAGE(support__cw_ops_manage_case_merge_temp[Abandon %])
RETURN
SWITCH(
TRUE(),
AbandonPercentage >= 0 && AbandonPercentage <= 4, "Green",
AbandonPercentage > 4 && AbandonPercentage <= 10, "Yellow",
AbandonPercentage > 10, "Red",
BLANK()
)
but I am getting the below
but I am getting the below
pls try this
CF = SWITCH( TRUE(), [Abandon %] <= 0.04,"#008000", [Abandon %]<= 0.1 ,"#FFFF00", "#FF0000" )or this
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() )значение матрице как вы посчитали?
вот так AVERAGE(support__cw_ops_manage_case_merge_temp[Abandon %])- 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 measurewhy 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"
)