How to set a grouped-by column to be used as the legend values in a TIme series chart?

Grafana Dashboards
1
  • What Grafana version and what operating system are you using?
    Grafana Cloud

I have the following result (queried from InfluxDB 3.0 with the InfluxDB official data source plugin).

image
image1375×572 27.7 KB

Currently, the legend shows Current, AdjustedChargeCurrentLimit and AdjustedDischargeCurrentLimit.

image
image1385×574 33.5 KB

I want the legend to list all the instances and allow me to visualize altogether or any combination of specific ones. So, for this dataset the legend should contain: 1401B, 1402A, 1403A and so on.

Which transformation do I need to use to achieve this?

2

Adding the “Partition by values” transformation and setting the Field to instance generates the appropiate timeseries tables (one per instance)

image
image615×303 17.5 KB

image
image1388×877 52.1 KB

Still, the line chart insists in showing all column values in the legend list instead of just the instance.

image
image1393×580 66.6 KB

For sure this is a very common requirement to visualize data. How is this that hard? What am I’m missing here?