I am currently using this InfluxQL query
SELECT sum("packets_received") * 60 FROM "ping" WHERE ("url" =~ /^$instance$/) GROUP BY time(1d) fill(null) ORDER BY time DESC tz('Europe/Vienna')
This works great and gives me the uptime per day.
Now I want to create an additional panel which shows the uptime per month. Since that is not possible with InfluxQL, I want to transition this query to flux which does support this.
I am a total noob and would appreciate any help I can get