I'm new to Kibana and Elasticsearch, I used Kibana and Elastic Search for our log aggregation.
My data is simple like this : id , time , username , spentGold , earnGold .
I can make line charts :
- Total SpentGold hourly
- Total EarnGold hourly.
Now, I want to get a chart :
- ( Total EarnGold / Total SpentGold ) hourly.
Does Kibana support it now , how can I make it.
Thank you very much.
Update 1 :
in my any log rows : SpentGold and EarnGold can not be both positive numbers .
if SpentGold > 0, then EarnGold =0
if EarnGold >0 , then SpentGold =0
SpentGold and EarnGold sometimes can be both = 0 .