How to sum two metric inside a data table

Elastic Stack Kibana
1

Hello,

I've started to work with Kibana this week to make some graphs with the data I do have from Google Analytics. I'm trying to make a few calculations based on the columns that I already have in my visualizations without luck.

My main goal is to get this three calculations:

Conversion rate : 100 / (sessions/transactions)
Session value: revenue / sessions
Avg. order value: revenue / transactions

My current data table looks like this:

09
Captura de pantalla 2019-02-04 a las 12.11.09.png2480×928 193 KB

I've tried with scripted fields and bucket aggregations but didn't get what I was expecting. Any clue on how to make it? Thank you!

2

Have you tried using Canvas? That will allow you to manipulate the aggregation results

3

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