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!