Configure panel to multiple one metric to all others

Grafana Dashboards
1

Hi, we’re trying to combine metrics in a panel that will have a large number of metrics. The idea is: we need an aggregate value, and one metric should be multiplying all the others. I’ve been fighting with transformations for a long long time, but zero success.

Is this possible?

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

We use grafana 10.2

  • What are you trying to achieve?
  • Load multiple metrics from a datasource:
Time  MetricA   MetricB  MetricC ....
...        90       0.5        0.4
...       100       0.6        0.5
  • Get an aggregate of all metrics on time (e.g. Last*), and multiple the first MetricA to all others.
MetricB   MetricC
    60        50

  • How are you trying to achieve it?
    The query always returns data in that format. We are trying to use transformations.

  • What happened?
    The closest I got was something like:

             Last       MetricA
MetricB       0.6          100
MetricC       0.5
  • What did you expect to happen?
    To get the final multiplication
MetricB   MetricC
     60             50