Expression Query generated same metric name for all metrics in a query

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    9.5.7

  • What are you trying to achieve?
    Resampling data on a query with multiple metric (mysql)

  • How are you trying to achieve it?
    Using a resample expression in Query

  • What happened?
    All the metrics are labeled with the same query name

  • What did you expect to happen?
    A unique name by resampled metric, so that they can be accessed individually

Screenshot from 2023-09-30 00-35-31
Screenshot from 2023-09-30 00-35-311030×481 40.1 KB

2

Hello, I have the same issue…
grafana v9. 1.6

When I change one metric name in the Overrides panel, all metrics names change !

This issue occurs when I add the latest query , wich content the same topic as the first one:

from(bucket: "BddNew")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["_field"] == "value")
  |> filter(fn: (r) => r["topic"] == "/Exterieur/Maison/Prod")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "OldMesure")

  from(bucket: "BddNew")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["topic"] == "/Solaire/ECU/408000047303/out" or r["topic"] == "/Solaire/ECU/408000158298/out" or r["topic"] == "/Solaire/ECU/408000047182/out")
  |> filter(fn: (r) => r["_field"] == "p0" or r["_field"] == "p1")
  |> group(columns: ["_time", "_field"], mode: "by")
  |> group()
  |> aggregateWindow(every :2m, fn : sum)
  |> yield(name: "OldPanneaux")


from(bucket: "BddNew")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["topic"] == "/Solaire/ECU/1" or r["topic"] == "/Solaire/ECU/2" or r["topic"] == "/Solaire/ECU/3" or r["topic"] == "/Solaire/ECU/4" or r["topic"] == "/Solaire/ECU/5" or r["topic"] == "/Solaire/ECU/6" )
  |> filter(fn: (r) => r["_field"] == "pwr_0" or r["_field"] == "pwr_1" )
  |> group(columns: ["pwr_0", "pwr1"], mode: "by")
  |> group()
  |> aggregateWindow(every : 5m, fn : sum)
  |> yield(name: "NewPanneaux")


Amp = from(bucket: "BddNew")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["_field"] == "value")
  |> filter(fn: (r) => r["topic"] == "/Exterieur/Maison/Prod")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)

Volt = from(bucket: "BddNew")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["_field"] == "value")
  |> filter(fn: (r) => r["topic"] == "/BorneVE/Tension")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)

join1 = join(tables: {Amp: Amp, Volt: Volt}, on: ["_time"])
  |> map(fn: (r) => ({ r with _value: r._value_Amp  * r._value_Volt }))
  |> drop(columns: ["_value_Amp", "_value_Volt"])
  |> map(fn: (r) => ({r with _value: r._value / 241.001 }))
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "NewMesure")

It’s a bug or I’ve done something wrong?