Hi, I want to create a dashbaord were (among other things) the energy consumption per month and year is displayed. I read a lot of threads were other have the same problem / they don´t know how to do this correctly.
I´m running InfluxDB v1.8.4 with Grafana v7.5.3.
At the moment I doing the monthly report like this:
SELECT count(distinct("value")) / 1000 FROM "autogen"."Arbeitszimmer_Steckdose_Schreibtisch_EnergyTotal" WHERE $timeFilter GROUP BY time(30d,-2h) fill(none)
But here I´m using not a “real month”, e.g. with just 28 or 31 days.
Any idea? Is it even possbile?
EDIT: Here I read that it should be possible, but the Link to the article i broken, see How to Build Grafana Dashboards with InfluxDB, Flux & InfluxQL and then " * Window by calendar months and years . Grouping by month works whether a month contains 28, 29, 30, or 31 days, and grouping by year works for regular and leap years."