# How to calculate growth rate?

**URL:** <https://discuss.elastic.co/t/how-to-calculate-growth-rate/134572>\
**Category:** Kibana\
**Created:** [June 5, 2018, 9:05am UTC](https://discuss.elastic.co/t/how-to-calculate-growth-rate/134572 "2018-06-05T09:05:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PhilippeCourtemanche](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PhilippeCourtemanche](https://discuss.elastic.co/u/PhilippeCourtemanche)\
**Post date:** [June 5, 2018, 9:05am UTC](https://discuss.elastic.co/t/how-to-calculate-growth-rate/134572/1 "2018-06-05T09:05:02Z")

</div>

I have this graph, which was built with with this mysql data. I'd like to be able to calculate the growth rate in the past year let's say.

 ![graph](https://us1.discourse-cdn.com/elastic/original/3X/c/0/c038583a81908c2f26d7b872e289f5822fc40a48.png) ![mysqldata](https://us1.discourse-cdn.com/elastic/original/3X/9/6/96e6a5aa2325e579ab49d60849413245310bc651.png)

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [June 5, 2018, 2:44pm UTC](https://discuss.elastic.co/t/how-to-calculate-growth-rate/134572/2 "2018-06-05T14:44:21Z")

</div>

Hey @PhilippeCourtemanche, you can use the Derivative of the Cumulative Sum of the field that you use to track an individual sale in a configuration similar to the following:

![41%20AM](https://us1.discourse-cdn.com/elastic/original/3X/c/2/c25063f285a2ff9dde082d736f05c9d22ec1bdcd.png)

---

<div class="post-metadata">

**Author:** ![PhilippeCourtemanche](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PhilippeCourtemanche](https://discuss.elastic.co/u/PhilippeCourtemanche)\
**Post date:** [June 8, 2018, 2:11pm UTC](https://discuss.elastic.co/t/how-to-calculate-growth-rate/134572/3 "2018-06-08T14:11:18Z")

</div>

Thanks for the reply  
Would it be possible to do this in the "metric" visualization?  
I can't see the "derivative" aggregation in the metric visualization.

I actually just want to display one number next to the above graph in order to show the past year's growth rate.

---

<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:** [July 6, 2018, 2:21pm UTC](https://discuss.elastic.co/t/how-to-calculate-growth-rate/134572/4 "2018-07-06T14:21:04Z")

</div>

Closed on July 6, 2018, 2:21pm UTC

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