CODEWITHSUNDEEP
grafanainfluxdbflux
kmlZ1337
kmlZ1337

Reputation: 62

Grafana - How to filter data by time

How to filter data with 1d interval. I'm trying to create bar chart with my PV system production and I need last value of day_kWh field over past 7 days. e.g: enter image description here

So far my code looks like this:

from(bucket: "GrowattBucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Growatt 4000TL3-S")
  |> filter(fn: (r) => r["_field"] == "day_kWh")

Upvotes: 0

Views: 663

Answers (1)

Amerousful
Amerousful

Reputation: 2545

I can't check with your data... but try this:

   |> aggregateWindow(every: 1d, fn: last)

Upvotes: 1

Related Questions