I would like to represent in Kibana the ratio Number of purchases/ Number of customers but only for the purchases with a marge superior at 10.
In other words we need to do :
es(index=log,timefield='@timstamp',q='PurchaseDone:1 AND SellPrice-BuyingPrice :>100',metric='cardinality:ID).divide(.es(index=log,,timefield='@timestamp',metric='sum:Id'))
but it s not working.
Do you have any ideas?