Adding time shifted mean min max to bar chart of hourly consumption

Grafana Bar Chart Panel
, , ,
1

by recording the absolute values of my energymeter I get the values and a bar chart of my hourly consumption by

SELECT spread("value") FROM "kWh" WHERE ("entity_id"::tag = 'energy_total_statistics') AND $timeFilter GROUP BY time(60m) fill(none)

How can I get the hourly consumption of yesterday as a second bar? Do I have to add a second query with

$timeFilter-1d

How can I get the mean / min / max of hourly consumption of the last 14 days (or selectable timespan) shown in my chart?

2

I stuck with trying to add the second graph with the consumption of yesterday into the same panel. How can I do this? Any advise for me?