# How to visualize the Sum,Max of serial diff aggregated values

**URL:** <https://discuss.elastic.co/t/how-to-visualize-the-sum-max-of-serial-diff-aggregated-values/222436>\
**Category:** Kibana\
**Created:** [March 6, 2020, 10:04am UTC](https://discuss.elastic.co/t/how-to-visualize-the-sum-max-of-serial-diff-aggregated-values/222436 "2020-03-06T10:04:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![avishnu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/avishnu/32/41289_2.png) [@avishnu](https://discuss.elastic.co/u/avishnu)\
**Post date:** [March 6, 2020, 10:04am UTC](https://discuss.elastic.co/t/how-to-visualize-the-sum-max-of-serial-diff-aggregated-values/222436/1 "2020-03-06T10:04:07Z")

</div>

Hi Team,

I have a CSV file in the below format.All the values corresponding to the ACK,BYE,INFO and PRACK are cumulative not absolute values .We are using logstash for parse and send this values to elastic search.

|Sat Nov 9 00:00:01 GMT 2019|ACK|6824505|BYE|1853415|INFO|3|PRACK|1459953|  
|Sat Nov 9 00:01:01 GMT 2019|ACK|6824583|BYE|1853425|INFO|3|PRACK|1459973|  
|Sat Nov 9 00:02:01 GMT 2019|ACK|6824690|BYE|1853439|INFO|3|PRACK|1460032|  
|Sat Nov 9 00:03:01 GMT 2019|ACK|6824720|BYE|1853446|INFO|3|PRACK|1460043|  
|Sat Nov 9 00:04:01 GMT 2019|ACK|6824811|BYE|1853454|INFO|3|PRACK|1460092|  
|Sat Nov 9 00:05:02 GMT 2019|ACK|6824878|BYE|1853464|INFO|3|PRACK|1460124|

The requirements are,  
1.Basically to plot the difference between the values/minute.For this we are using kibana serial diff aggregation with an interval of 1 minute.  
2.The next requirement is to find the Sum and Maximum values of the serial difference calculate in the first requirement.

We are struggling to achieve the second one with Kibana.It would be great ,if someone can help us on this.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 12, 2020, 2:29pm UTC](https://discuss.elastic.co/t/how-to-visualize-the-sum-max-of-serial-diff-aggregated-values/222436/2 "2020-03-12T14:29:34Z")

</div>

You can do the the Sum with "Cumulative Sum" parent pipeline aggregation, but I don't thing you can calculate the Max of that serial diff.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 9, 2020, 2:29pm UTC](https://discuss.elastic.co/t/how-to-visualize-the-sum-max-of-serial-diff-aggregated-values/222436/3 "2020-04-09T14:29:46Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.