# Elastic - Kibana: One of the table column to display relative change is percentage (relative to time chosen in time-picker)

**URL:** <https://discuss.elastic.co/t/elastic-kibana-one-of-the-table-column-to-display-relative-change-is-percentage-relative-to-time-chosen-in-time-picker/234172>\
**Category:** Kibana\
**Created:** [May 25, 2020, 3:13pm UTC](https://discuss.elastic.co/t/elastic-kibana-one-of-the-table-column-to-display-relative-change-is-percentage-relative-to-time-chosen-in-time-picker/234172 "2020-05-25T15:13:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pramodh\_Bettadapura](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pramodh_bettadapura/32/69016_2.png) [@Pramodh\_Bettadapura](https://discuss.elastic.co/u/Pramodh_Bettadapura)\
**Post date:** [May 25, 2020, 3:13pm UTC](https://discuss.elastic.co/t/elastic-kibana-one-of-the-table-column-to-display-relative-change-is-percentage-relative-to-time-chosen-in-time-picker/234172/1 "2020-05-25T15:13:48Z")

</div>

0

I need to create a table visualization in Kibana, with logs associated with timestamp. I am able to populate first 2 columns `Vehicle Name` and `Count` using _Aggregators_ and _Terms_ . And the values changes as expected with the time-picker value.

What I need is the third column `Rate` which is the relate change in percentage with reference to past value.

For example: when the user uses the time-picker to pick the time as **last 1 hour**. `Count` column displays the last 1 hours sum value. The 3rd column `Rate` should display past 2hr-to-1hr value.

Is there a way in elastic/kibana to populate such value?

```
    (now - 1 hour)
    |---------------------|----------------|----------------|
    | Vehicle Name | Count | Rate(%) |
    |---------------------|----------------|----------------|
    | X1 | 34 | 0% |
    |---------------------|----------------|----------------|
    | X2 | 43 | 15% |
    |---------------------|----------------|----------------|
    | X3 | 41 | -10% |
    |---------------------|----------------|----------------|
    | X4 | 14 | -30% |
    |---------------------|----------------|----------------|
```

---

<div class="post-metadata">

**Author:** ![lukeelmers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukeelmers/32/35230_2.png) [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)\
**Post date:** [May 25, 2020, 10:05pm UTC](https://discuss.elastic.co/t/elastic-kibana-one-of-the-table-column-to-display-relative-change-is-percentage-relative-to-time-chosen-in-time-picker/234172/2 "2020-05-25T22:05:19Z")

</div>

There isn't a way to track percentage change from a previous value yet, however there is [this Github issue for the enhancement](https://github.com/elastic/kibana/issues/62381) in case you'd like to follow along or give the original comment a 👍

---

<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:** [June 22, 2020, 10:05pm UTC](https://discuss.elastic.co/t/elastic-kibana-one-of-the-table-column-to-display-relative-change-is-percentage-relative-to-time-chosen-in-time-picker/234172/3 "2020-06-22T22:05:28Z")

</div>

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