Flux: Label Description

Grafana
, , ,
1

Hi Together,

I have an Issue with my grafana Table. I will add Instead of the Time stamp the cw (calendar week) for each pillars (for examble cw2, cw3 …) . Is this possible? I am using Influx DB2.x

Thanks

Bye

image
image2485×1654 78.8 KB

import "timezone"
option location = timezone.location(name: "Europe/Berlin")
 
 
from(bucket: "My_DB")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "smartmeter.0.1-0:1_8_0__255.value")
  |> filter(fn: (r) => r["_field"] == "value")
  |> aggregateWindow(every: 1w, fn: last, timeSrc: "_start", createEmpty: false, offset: -3d)
  |> difference(nonNegative: true, columns: ["_value"])
 
  |> map(fn: (r) => ({
        r with 
        kw: string(v: time(v: r._time))
     }))
  |> yield(name: "weekly_mean")
2

Hi @larsmueller2 ,

I have resolved the issue by following the steps outlined below:

Step 1. Created a new bucket and inserted dummy data.

Step 2. Integrated InfluxDB with Grafana.

Step 3. Configured the panel query

import "date"
from(bucket: "Dummy_data")
  |> range(start: -0)
  |> filter(fn: (r) => r["_field"] == "value")
  |> aggregateWindow(every: 1w, fn: last, timeSrc: "_start", createEmpty: false)
  |> difference(nonNegative: true, columns: ["_value"])
  |> map(fn: (r) => ({
        r with 
        week_label: "CW " + string(v: date.week(t: r._time))
     }))

Final output :-

image
image1062×511 18.7 KB

image
image1366×768 101 KB

3

Thanks for your Great Help. Problem is solved. You are the best :grinning_face:

4

Hi @larsmueller2,
If your issue has been resolved, please mark the solution accordingly. Thank you!