Need to add conditional formatting on the basics of Time like HH

[EnriqueS]

Hello, here what @Max was suggesting in the other topic is:

1. to use the extract function on the date you have to get just the hour ‘HH’ portion of it
2. then use conditional formatting for the coloring.

I was able to test this successfully in my account, posting here the steps I followed:

1. Create a calculated field (hour) to extract the hour from the date field:

extract('HH', {your_date_field_here})

2. Use the conditional formatting with the rules depicted below in the hour field:

Hope it helps, please mark this solution as solved if that’s the case also to help other members of the community., otherwise let us know.

Happy dashboarding!