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

Elastic Stack Kibana
1

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%       |
    |---------------------|----------------|----------------|
2

There isn't a way to track percentage change from a previous value yet, however there is this Github issue for the enhancement in case you'd like to follow along or give the original comment a :+1:

3

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