Possible to combine two lines into one?

Grafana InfluxDB
1

Hello,
It so happened that I have two different friendly names for 1 entity_id in my Home Assistant. As a result of it, the graph shows 2 different line colours and the legend shows two separate desriptions for these lines.
How to combine them so that Grafana treats them as one?
Is it possible?

from(bucket: "Baza")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "units")
  |> filter(fn: (r) => r["domain"] == "sensor")
  |> filter(fn: (r) => r["entity_id"] == "vicare_burner_starts")
  |> filter(fn: (r) => r["friendly_name"] == "E3_Vitodens_200_0421 Burner starts" or r["friendly_name"] == "Starty palnika")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "last")

Grafana - 2 lines
Grafana - 2 lines998×230 36.8 KB

2

Hi @robertjot

How about this?

Query A:

from(bucket: "Baza")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "units")
  |> filter(fn: (r) => r["domain"] == "sensor")
  |> filter(fn: (r) => r["entity_id"] == "vicare_burner_starts")
  |> filter(fn: (r) => r["friendly_name"] == "E3_Vitodens_200_0421 Burner starts")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "query_A")

Query B:

from(bucket: "Baza")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "units")
  |> filter(fn: (r) => r["domain"] == "sensor")
  |> filter(fn: (r) => r["entity_id"] == "vicare_burner_starts")
  |> filter(fn: (r) => r["friendly_name"] == "Starty palnika")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "query_B")

and then:
image

3

Thank you very much.
I’ll try it.