Grouping values to see a entire month/week


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:

  sum(P_Plus) AS "P_Plus"
FROM $meterID

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?


I’m guessing this is possible, but you might have to transform your data in just the right way.

Can you inspect your raw request and response? and share it here in a code block?