I’m using Influx DB Cloud service to gather data from my energy counter. This is always a total number meaning the actual reading (not delta).
I’m able to agregate by month but i’m having two issues
- Data label is showing first day of a month instead of previous
- I would like to see months next to each other between the years. Meaning August’23 should be next to August’'24 but with dufferen colour. Doable?
My current dashboard code is:
from(bucket: “grentonNew”)
|> range(start: -14mo)
|> filter(fn: (r) => r[“_measurement”] == “eastron”)
|> filter(fn: (r) => r[“host”] == “totalconsumption”)
|> filter(fn: (r) => r[“_field”] == “value”)
|> difference()
|> aggregateWindow(every: 1mo, fn: sum, createEmpty: false)
|> yield()
