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

Grafana Elasticsearch
1

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 a “Table” - but I am ok with other visualizations as well)
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 one of the three columns (by using an appropriate query). But is there any way to get all these three Avg columns together?

Thanks.

2

This called Timeshift…

Try this:

Fadjar Tandabawana