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 yellow. Thanks for the help on this!
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.
2 Replies
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.
