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?