I have an elasticsearch index with following fields ...
OrderNo,StoreNo,OrderDate,Amount
I want to create a visualization that shows data like follows: (Most natural choice is
StoreNo | Avg Amount for last two days | Avg Amount for Yesterday | Avg Amount for Today
I am able to create the visualization with StoreNo and any of the three columns (by using an appropriate filter on the date). But is there any way to get all these three Avg columns together? (I am trying both Kibana and Grafana, so if you have a suggestion for either of them, that would be a great help.)
I know how I can do this in Kibana using Vega, but I am trying to find out if there is a simpler approach.
Thanks.
- Parag