Charting Grouped Statistics (Pivot table)

Let’s say that I have the following data set:

Week Day Consumption
1 Mon 5
1 Tue 1
1 Wed 9
2 Mon 4
2 Tue 3
2 Wed 8
3 Mon 6
3 Tue 2
3 Wed 8

And that I want to chart it based on average by grouped day, that is average consumption of Mondays, Tuesdays and Wednesdays. For example, in Excel this is done with a pivot table:

Day Avg Consumption
Mon 5.0
Tue 2.0
Wed 8.3

Can the lovelace charts be used for this, maybe based on a template sensor that calculates the grouped stats?