Representing ratio between two indexes or visualization

Juan_Francisco_Verho · September 13, 2019, 12:23pm

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?

Marius_Dragomir · September 13, 2019, 1:05pm

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

Juan_Francisco_Verho · September 17, 2019, 1:56pm

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

Marius_Dragomir · September 19, 2019, 1:39pm

Use the Math option in the aggregations.

Juan_Francisco_Verho · September 19, 2019, 7:43pm

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

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:

Juan_Francisco_Verho · September 20, 2019, 4:57pm

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

system · October 18, 2019, 4:57pm

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