Representing ratio between two indexes or visualization

Elastic Stack Kibana
1

Let's suppose I have two indexes and one visualization for each one:

IndexA with unique count of views per week
IndexB with unique count of likes per week

I would like to create a third visualization that is the ratio of views/likes for every week.
How can I do this?

2

Use the Math aggregation in the Visual Builder visualization. It will allow you to do most math operations on metrics.

3

I'm sorry. Can you be a little more specific? I tried with the Visual Builder filter ratio option but no luck.

4

Use the Math option in the aggregations.

5

Thanks but I don't know if that applies to my case. I can't add a math aggregation before applying filters.

34%20PM
Screen Shot 2019-09-19 at 9.42.34 PM.png1372×363 19.8 KB

Besides the previous structure, I'm also applying filters to get specific elements and I want to divide the two series after. I'm trying with both timelion and the visual builder.

I'm including screenshots:

20%20PM
Screen Shot 2019-09-19 at 9.13.20 PM.png1440×823 70 KB

38%20PM
Screen Shot 2019-09-19 at 9.41.38 PM.png1368×309 15.8 KB

6

Okay so timelion has a divide function for the timeseries. Is there something similar for the visual builder?

7

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