Hello @Biswajit_1993 , posting here the same response as in the other topic for coherence.
-
to use the extract function on the date you have to get just the hour ‘HH’ portion of it
-
then use conditional formatting for the coloring.
-
Create a calculated field (hour) using extract to get the hour from the date field:
extract('HH', {your_date_field_here})
- 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!