How to sum two metric inside a data table


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:

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!

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

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