I am tried to make so great kibana 4 tables and I am having a hard time.
I am trying to visualize data about marketing campaigns we are running.
I would like to be able to show on the same row, results from 2 different filters.
For example, one column to sum all rows with of type 1 and the second all rows of type 2.
The I would like to have a third column, whos value is column 2 divided by column 1?
Is this at all possible.
Also if I want to multiple the value I get in a column by 1000 before showing it is that possible.
For example mane the average calculation and then multiply it by 1000?
Thank you for you help