Correct value in Total row when field is calculation of ratio of two other fields

Grafana Table Panel
1

Grafana v9.5.17 (68b350c5e6896aa019656d6558d7d186895186be), running in Grafana Operator for OpenShift, version 5.8.0

I have a field (" field C") that is a binary operation of field A’s value divided by field B’s value. The table has a “Total” row that shows the sum of the values of each field, but for field C, I need the Total value to be the ratio of field A’s total value divided by field B’s total value. Instead, the Total value for field C is just the sum of the values of field C, which is a meaningless number.

For example, in this screenshot, the “Total” value in field C should be 18.4%, but it is 41.0%, which is meaningless.

Thanks in advance for your help!

image

2

welcome @wwillfred

It is meaningful as it is working as it is supposed to. What is your datasource?

3

Hi @yosiasz, my datasource is Prometheus.

4

unless you can do the summations and calculations in the data source itself you might want to go to the dynamic text plugin route

image
image1213×636 60.7 KB

1 Like