Legend value not formatting when more than one value

[bck01215]

Seen here the disk groups all have the same value

[mamorett]

Hi. Are you using LEGEND FORMAT option in your query ? That supports only one value. For more complex cases, like multi values substitution you should use regex transformation: https://grafana.com/docs/grafana-cloud/whats-new/2024-11-19-new-regular-expression-option-for-extract-fields-transformation/

[bck01215]

Your docs indicate multiple values can be used.

Additionally regex transformations still do not work because

1. not all fields are returned on the object (such as diskGroupName) unless I filter that dimension
2. the fields that are returned are identical as in the last screenshot (this also occurs without LEGEND FORMAT)

[bck01215]

Here is the query with unique_id values templated out but showing repition

{
  "request": {
    "url": "api/ds/query?ds_type=oci-metrics-datasource&requestId=SQR157",
    "method": "POST",
    "data": {
      "queries": [
        {
          "compartment": "compartment_id_as_value",
          "compartmentName": "$compartment",
          "datasource": {
            "type": "oci-metrics-datasource",
            "uid": "eeihzbtp90mpsa"
          },
          "dimensionValues": [],
          "groupBy": "select option (optional)",
          "hide": false,
          "interval": "[5m]",
          "intervalLabel": "5 minutes",
          "legendFormat": "",
          "metric": "ASMDiskgroupUtilization",
          "metricNames": "$resourcegroup",
          "namespace": "oci_database_cluster",
          "queryText": "ASMDiskgroupUtilization[5m].max()",
          "queryTextRaw": "",
          "rawQuery": true,
          "refId": "A",
          "region": "us-ashburn-1",
          "resourcegroup": "NoResourceGroup",
          "statistic": "max()",
          "statisticLabel": "maximum",
          "tagsValues": [],
          "tenancy": "DEFAULT/",
          "tenancyName": "DEFAULT/",
          "datasourceId": 288,
          "intervalMs": 15000,
          "maxDataPoints": 1448
        }
      ],
      "from": "1744352124829",
      "to": "1744373724829"
    },
    "hideFromInspector": false
  },
  "response": {
    "results": {
      "A": {
        "status": 200,
        "frames": [
          {
            "schema": {
              "name": "response",
              "refId": "A",
              "meta": {
                "typeVersion": [
                  0,
                  0
                ],
                "executedQueryString": "ASMDiskgroupUtilization[5m].max()"
              },
              "fields": [
                {
                  "name": "time",
                  "type": "time",
                  "typeInfo": {
                    "frame": "time.Time"
                  }
                },
                {
                  "type": "number",
                  "typeInfo": {
                    "frame": "float64"
                  },
                  "labels": {
                    "region": "us-ashburn-1",
                    "tenancy": "DEFAULT",
                    "unique_id": "unique_id_2"
                  }
                },
                {
                  "type": "number",
                  "typeInfo": {
                    "frame": "float64"
                  },
                  "labels": {
                    "region": "us-ashburn-1",
                    "tenancy": "DEFAULT",
                    "unique_id": "unique_id_1"
                  }
                },
                {
                  "type": "number",
                  "typeInfo": {
                    "frame": "float64"
                  },
                  "labels": {
                    "region": "us-ashburn-1",
                    "tenancy": "DEFAULT",
                    "unique_id": "unique_id_1"
                  }
                },
                {
                  "type": "number",
                  "typeInfo": {
                    "frame": "float64"
                  },
                  "labels": {
                    "region": "us-ashburn-1",
                    "tenancy": "DEFAULT",
                    "unique_id": "unique_id_2"
                  }
                },
                {
                  "type": "number",
                  "typeInfo": {
                    "frame": "float64"
                  },
                  "labels": {
                    "region": "us-ashburn-1",
                    "tenancy": "DEFAULT",
                    "unique_id": "unique_id_1"
                  }
                }
              ]
            },
            "data": {
              "values": [
                [timestamps...
                ],
                [values...
                ],
                [values...
                ],
                [values...
                ],
                [values...
                ],
                [values...
                ]
              ]
            }
          }
        ],
        "refId": "A"
      }
    }
  }
}

[bck01215]

Hi. Are you using LEGEND FORMAT option in your query ? That supports only one value. For more complex cases, like multi values substitution you should use regex transformation: https://grafana.com/docs/grafana-cloud/whats-new/2024-11-19-new-regular-expression-option-for-extract-fields-transformation/

In case it was unclear, I only expect one value to be returned but I expect that value to be unique for each series returned assuming I use unique tags in the templating.