I am looking to have two different sum numbers on the same field but on different filters. The filed is related to trade status which can be 'successful', 'not successful', 'incomplete', 'partly done' etc. I am looking to sum on "trade quantity" for two of the above trade statuses and then I need to perform a ratio of those two. How can that be done?
I was thinking to use Metric->Advanced-> json input to create a filtered and same again for another filtered sum and then a 3rd metric to show the ratio using painless.