Forum Discussion
Solved
Conditonal Formatting Duration Help.
Hello I am having trouble getting the right condition format to highlight a color based off duration. Idea is say for example if the talk time is greater than 15 minutes, it should highlight yel...
Thanks for the response. I was able to do it with
= IF(([Average Handle time])>TIMEVALUE("00:15:00"),1,0) which made columns on the table and from there I was able to plot the colors using the built in formatting tool.
stateofazzie , Create a color measure and use that in conditional formatting using filed value option
if( [Avg talk time] > time(15,0,0), "yellow", "white")
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Thanks for the response. I was able to do it with
= IF(([Average Handle time])>TIMEVALUE("00:15:00"),1,0) which made columns on the table and from there I was able to plot the colors using the built in formatting tool.