Bar chart : Display purchases per product for the current day and the previous day

Hello,

Grafana version : v10.4.0
DataBase : Opensearch

I’m looking for a solution to display in a “Bar Chart” the number purchases per product for the current day and the previous day.

To illustrate this need, here is a sample of data.

image

And that’s the representation I would ultimately like.

Here is the query to display the number of purchases per product for the current day :

To display the number of purchases from the previous day in the same chart, I’m wondering if I should add a metric with a Moving function. Honestly, I really don’t know…

Any help is welcome.

Regards,