Table in Kibana with ratios

[stefano_guerrieri]

Dears,
I have this raw data in Elastic:

I need first to create in Kibana a table like that one:

but the most important is that I have to create a table based on the aggregation above like the following (i'm highlighting the excel formulas to reproduce in Kibana):

Is there a way to make in Kibana the tables I need (especially the last one)?

Thank you very much

[cheiligers]

@stefano_guerrieri, welcome to the forum!
You can make the tables you need in Kibana as visualizations using Filter Ratios and the filters that TSVB offers. I gave a guide on how to do this in this post If you select your Past Due field as the 'Carrier' from the example in the post I reference and then use the month of January as the numerator field and February as the denominator, you'll get the ratio you need. You'll have to set the format for the field as percentage in the options tab for the series.
If you want a quick introduction to Kibana, here's a great webinaar, for an intro to visualizations in Kibana, I recommend this guide.
Good luck!

[stefano_guerrieri]

Hi @cheiligers, thanks for your reply. The issue we have is that we need to make a ration between data of a month and data of a month before. It is like in your case for each carriers you want to do the ratio between number of ES-air of Aprile / number of Logstash airways of march. How I can do it? A ratio will works in each group by cluster, so it will consider only the document of ES-air or of Logstash airways, because of the group by

[cheiligers]

You'll need to use a range query on dates for the month before and month after to get the result you want.

[jeipo_91 (Gianluca)]

Hello Cheilingers, I'm a colleague of Stefano. Solution above would imply a different filter for each one column and columns of course would be added one after the other.

As a consequence, if we wished to have ratio pd30/pd60 and ratio pd60/pd90, we'd need two different table correct?
Thanks in advance for your reply.
Gianluca