Grouping values to see a entire month/week

Grafana Bar Chart Panel
,
1

Hello,

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?

Thanks

2

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?