Color different time intervals by expression

[barbarapoblocka]

Hello,

I'd like to show a graph on which different time intervals are classified as different colors.

So I am calculating the difference in min between the event and the planned time vs. the number of occurrence.

My dimension looks like this: =Interval(Class(Event_Time - Planned_Time, '00:05:00'), 'hh:mm')

The goal would be to classify different time intervals and color them depending on how far away from the value 0:00 they are. 

e.g

-00:10    until    0:10:00 blue

etc.

does anyone has an idea how to do it? Nothing what I tried so far worked...

[crusader_]

Hi,

Just change you colors by Expression and put appropriate condition inside.

Check below example:

Expression:

=IF((MAX(TOTAL DATE)-DATE)<10, ARGB(150,200,20,30),
	IF((MAX(TOTAL DATE)-DATE)<15, ARGB(150,20,20,230), ARGB(150,20,230,20)))

Hope this helps.

//Andrei