I have a tasks that creates a display that shows certain colors depends on value calculated. The tasks is similar to this blog Simple Gantt visualization.
these are the following values that represents every color. 0 - blue, 1 - yellow, 2 - red.
The calculation generates that if there is an event for greater than 2 minutes and less than 2 hours, the value should be 1, and if there is an event for greater than 2 hours the value is 2, else 0.
My problem is that the client likes to change the color of yellow for the last 2 hours if there is already red.
How can I manipulate the colors in a trends if this is already history data?