How to create a visualization with data for last two days, for yesterday and for today

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

A correction needed. In my original post I wrote:

The sentence got cut-off half way and I didn't catch that. Sorry about that. It should have been:

I want to create a visualization that shows data like follows: (Most natural choice is a Table Visualization, but I am ok if there is a different visualization that would work).

There is no way to do this with the normal data table in kibana. You can try with the Enhanced Data Table plugin created by the community.

Thank you. Will try.

-- Parag