I have
color total_value @timestamp
red 90 X
red 90 X
blue 80 X
yellow 70 X
red 90 X
blue 80 X
yellow 70 X+1
red 90 X+1
what I need is sum(max of each color) = 90+80+70
I want to draw line of this value over time. how do I achieve this in kibana?