Table panel footer: different functions for different columns

Grafana Table Panel
,
1

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

  • What are you trying to achieve?
    See below: have the footer calculate the Mean for one column and the Max for another
    Illustration

  • How are you trying to achieve it?
    I haven’t found any documentation on this being possible. I’ve tried tweaking the panel settings to no avail.

  • What happened?
    I can at most have the Mean calculate only for 1 column or the Max only for another, but not one calculation for each.

  • What did you expect to happen?
    I expected to see a setting where one can define how to aggregate each column.

  • Can you copy/paste the configuration(s) that you are having problems with?
    Description above should be enough, otherwise let me know.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No.

  • Did you follow any online instructions? If so, what is the URL?
    No.

2

this isn’t possible as described, but you can add new fields from a calculation using transformations

1 Like
3

But those fields are new columns by definition, never new rows, right?

4

that’s correct. Grafana’s data frame model is columnar oriented, not row oriented. I personally don’t know any way to add an extra row to the bottom of a table with pre-existing rows in grafana :frowning_face:

1 Like
5

Well, the “Show footer” option does add a row
Screenshot 2022-02-11 134527

But it’s not possible to have different calculations for different rows, I wonder if others wouldn’t find that useful too.

8 Likes
6

Totally…I have some columns that I would like to sum and others that I want a mean. Is sad that is not possible.

3 Likes
7

what is your data source?

8

It’s InfluxDB (v1 still)