Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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