Transformations in Grafana
You can use transformations in Grafana to process the data from a query before Grafana shows it. With transformations, you can join queries, rename fields, perform mathematical operations, and so on.
To access the transformation feature, go to the Transform tab in the panel editor, as you can see in Figure 9.3:
Figure 9.3 – Transform tab
Take into account that, sometimes, the resulting data isn’t shown in the panel because of some incompatibility with the type of panel. In these cases, you can switch the panel to Table view at the top of the screen. In this mode, you will be able to see the results as a table and analyze whether they are what you are looking for.
If you apply more than one transformation, the order of them is important. Each transformation passes the result to the next, forming a pipeline. So, changing the order can modify the final result.
Finally, to apply transformations, you need a working...