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??
Panel:
Query:
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):
