# Compounded Monthly Growth Rate **URL:** \ **Category:** Kibana\ **Created:** [February 23, 2017, 2:07pm UTC](https://discuss.elastic.co/t/compounded-monthly-growth-rate/76233 "2017-02-23T14:07:26Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Tomaz\_Bratanic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tomaz_bratanic/32/15713_2.png) [@Tomaz\_Bratanic](https://discuss.elastic.co/u/Tomaz_Bratanic)\ **Post date:** [February 23, 2017, 2:07pm UTC](https://discuss.elastic.co/t/compounded-monthly-growth-rate/76233/1 "2017-02-23T14:07:26Z")
Any idea of how I could calculate this in timelion or a custom metric Equation is like this \> Latest Month # of users/ First Month # of users)^(1/# of Months) -1 But I have no idea how to start. Thanks ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [February 23, 2017, 10:55pm UTC](https://discuss.elastic.co/t/compounded-monthly-growth-rate/76233/2 "2017-02-23T22:55:27Z")
You won't be able to calculate the compounded growth rate for a couple reasons. There's no way to access the number of months that have already passed in an expression. And there's also no exponential function. However, you might be able to calculate a growth rate without compounding. Would something like this serve your purpose? ![](https://us1.discourse-cdn.com/elastic/original/2X/0/050621181803075ab1b1ac29916659878c80ca65.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 23, 2017, 10:55pm UTC](https://discuss.elastic.co/t/compounded-monthly-growth-rate/76233/3 "2017-03-23T22:55:28Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.