I would like to color the cells from a column table depending on their time value
For cells with values lower than 00:05:00 it should be green
For cells between values 00:05:00 and 00:15:00 it should be orange
For cells higher than 00:15:00 it should be red
Thanks @niketn-deceased but I tried another way and it worked fine!
<colorPalette type="expression">case (value =="-", "", value > "00:15:00","#D3828C", value <= "00:05:00" ,"#C8E8C6", value > "00:05:00" and value <= "00:15:00","#F2B094"</colorPalette>
@anonuser you will have to adopt the concepts from the following answer and change as per your needs. As far as you are able to use SPL to create a new field for applying color as per Time (same way you have defined in your question), you will need to use the new field for color SLA and use eval to suffix with a delimiter to the required field where you want color applied. Next you split the values by delimiter and then apply color using expressions colorPalette and finally use CSS override to hide the field value for color SLA that you have created.
Please try out and confirm!