i’m using Grafana 8.5 free and want to design my bar-chart in a way, that it shows the sum of values per week (Monday-Sunday)
I’m using this query:
SELECT $__timeGroupAlias(TS,7d), sum(P_Plus) AS "P_Plus" FROM $meterID GROUP BY 1 ORDER BY $__timeGroup(TS,7d)
Obviously this groups the value always by the last 7 days. What I want is even if today is wednesday i want to see the weekly sums of the values always from monday-sunday.
Is that possible with this plugin? If no, are there alteratives?