-
What Grafana version and what operating system are you using? 11.5.1 with a Prometheus datasource
-
What are you trying to achieve? I’m trying to design a table that will show particulat services status for some servers. There are 24 services and - at this stage of development - five servers. I want this table to have servers as columns and services as rows.
-
How are you trying to achieve it? I use 24 queries and a handful of transformations including “Group by” in which I select calculating the lastNotNull value. At the end I get columns named “<service_name> (lastNotNull)”. I get rid of the “(lastNotNull)” part with “Organize fields by name” and it’s renaming function. That fixes the columns’ names so I proceed with the final transformation.
-
What happened?
When I do the “Transpose” to turn the whole thing sideways to achieve it’s desired look, Grafana “forgets” about the renaming done in the previous transformation and I get stuck with <service_name> (lastNotNull). -
What did you expect to happen?
If transformations are considered/applied sequentially then I would expect that my first column will inherit its values from the previous transformation -
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. n/a
-
Did you follow any online instructions? I’ve searched community forums and asked a bunch of AIs (including Grot)
I’ve tried different transformations and ways to put them in order but I just can’t get it right. The closest I’ve got was when I used “Format string” transformation with “Substring” format, but it would require a possibility of counting chars from the right side. Maybe there is a different way to get rid of this “lastNotNull”, but as far as I know it is not possible.