How to sum two metric inside a data table

[mattbc (Matt)]

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:

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!

[Nathan_Reese]

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