Transforming Table Data Column to Label Row

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

8.5.4 on PC

  • What are you trying to achieve?

We have raw data logs from PostFix MTAs that are coming into Grafana via Elastic.

I want to turn a column with 4 values into a header row of a table then report on sum of the values

  • How are you trying to achieve it?

Not even sure how to go about this

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

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

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

I have been reading up on transformations and have tried a few options but can not seem to get the column values of Status to be the header row of the table.