Historical values in the same visualization as new values for comparison

Elastic Stack Kibana
1

For example you have an index with sales numbers for 2018 and 2019.
(Showing the number of sales for each date throughout the year.)
I want to compare the numbers for 2018 and 2019 in the same visualization, so the user can compare sales for 2018 and 2019.
Is this possible in Kibana?

2

Hi @Norway,

IIRC the Timelion visualization type supports offsetting a series by an interval.

3

Yes, the TSVB visualization type also supports an offset parameter. If you want to calculate the difference as a percentage, I've written a tutorial here: https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations

4

Excellent, that worked very well.
Thank you!
Your solution shows differences in percent, and that works well.
If you have the same comparison for numbers, let me know :slight_smile:

5

Thanks!
I have tried the offset function in Timelion, but I am not able to compare the numbers for for instance two different years.
If you have a tutorial for how you do it, it would be great to see it.

6

How does the problem manifest? I assume you tried setting the offset to something like -1y in Timelion?

7

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