# Sum of max value over time interval

**URL:** https://discuss.elastic.co/t/sum-of-max-value-over-time-interval/368030
**Category:** Kibana
**Created:** [September 30, 2024, 2:59pm UTC](https://discuss.elastic.co/t/sum-of-max-value-over-time-interval/368030 "2024-09-30T14:59:28Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)
#### Post date: [September 30, 2024, 2:59pm UTC](https://discuss.elastic.co/t/sum-of-max-value-over-time-interval/368030/1 "2024-09-30T14:59:28Z")

</div>

I have

```auto
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?

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [September 30, 2024, 3:03pm UTC](https://discuss.elastic.co/t/sum-of-max-value-over-time-interval/368030/2 "2024-09-30T15:03:03Z")

</div>

Hi @elasticforme  
What version?

In short  
Lens  
Line  
max (total\_value)  
Break down by color  
In the break down look for collapse by sum

---

<div class="post-metadata">

### Author: ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)
#### Post date: [September 30, 2024, 3:05pm UTC](https://discuss.elastic.co/t/sum-of-max-value-over-time-interval/368030/3 "2024-09-30T15:05:37Z")

</div>

currently using 8.5.3

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [September 30, 2024, 3:07pm UTC](https://discuss.elastic.co/t/sum-of-max-value-over-time-interval/368030/4 "2024-09-30T15:07:40Z")

</div>

Hmm I don't know if that collapsed by is in 8.5.3 Lens

If not, you will need to use TSVB

Max total\_value  
Group by color  
Series agg sum