# Growth over time using "metric" and "table" visualizations

**URL:** <https://discuss.elastic.co/t/growth-over-time-using-metric-and-table-visualizations/234717>\
**Category:** Kibana\
**Created:** [May 28, 2020, 10:20am UTC](https://discuss.elastic.co/t/growth-over-time-using-metric-and-table-visualizations/234717 "2020-05-28T10:20:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanzcans](https://avatars.discourse-cdn.com/v4/letter/s/eada6e/32.png) [@sanzcans](https://discuss.elastic.co/u/sanzcans)\
**Post date:** [May 28, 2020, 10:20am UTC](https://discuss.elastic.co/t/growth-over-time-using-metric-and-table-visualizations/234717/1 "2020-05-28T10:20:10Z")

</div>

Hello!

Is there any way to calculate the growth over time in the "metric" and "table" visualizations? I only have two fields in my index: timestamp and sales, and I would like to get something like this:

![table_growth](https://us1.discourse-cdn.com/elastic/original/3X/0/7/0732acd254294fe438bfaa8de275426a2564bcb1.png)

![metric_growth](https://us1.discourse-cdn.com/elastic/original/3X/9/9/9904d52abc90092fe94d4c3e63941c83cc986bf2.png)

I know that I can do it with the Timelion visualization (using the "offset" parameter), but I need to use tables and metrics.

Thank you very much!

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 23, 2020, 3:42pm UTC](https://discuss.elastic.co/t/growth-over-time-using-metric-and-table-visualizations/234717/2 "2020-06-23T15:42:49Z")

</div>

This kind of request is fairly common, but we don't have a great solution for you. It's a high priority for us to support this kind of calculation in Lens, so I have been planning out this work.

There is a workaround which you can do in the TSVB editor: if you set your time range to 2 years, and your time interval to 1 year, you can use the "serial difference" function to get the "previous" value. Screenshot here with example: [https://github.com/elastic/kibana/issues/35043](https://github.com/elastic/kibana/issues/35043)

---

<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 21, 2020, 3:54pm UTC](https://discuss.elastic.co/t/growth-over-time-using-metric-and-table-visualizations/234717/3 "2020-07-21T15:54:27Z")

</div>

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