"_value" is being appended to Data Labels in Status History panel

Hello. Apologies if this is a basic question. I’m learning, and so far my searches for an answer haven’t turned up anything helpful, (I’m probably not using the right terms).

I have a Status History panel showing average watt usage of 16 circuits in my house. The data labels on the left hand side all say “_value {device_name}”. I want them to just say “{device_name}”. I know I can manually re-label them, but I don’t like that solution as it seems clunky, won’t update dynamically if a name changes, and I figure there must be a better way. Is there a better way??



from(bucket: "vueDB")
  |> range(start: -6h)
  |> filter(fn: (r) => r["_measurement"] == "energy_usage")
  |> filter(fn: (r) => r["_field"] == "usage")
  |> filter(fn: (r) => r["account_name"] == "Jacobs home")
  |> filter(fn: (r) => r["detailed"] == "False")
  |> filter(fn: (r) => r["device_name"] != "Jacobs home")
  |> group(columns: ["device_name"], mode:"by")
  |> window(every: 15m)
  |> mean(column: "_value")
  |> rename(columns: {_stop: "_time",})
  |> group(columns: ["device_name"])

Table view in InfluxDB Explorer (same query):

these things happen because influxdb send kind of wrapped data (or multiple table).
you can try grafana transformation to work around :
-prepare time series
-label to field
maybe try to group in one table in influx before using label to field.

That worked! I don’t know why it worked, but I made no changes to the query or anything else, just did labels to fields and it’s fixed. Thanks!

1 Like