Hello, I had been looking for a way to correctly display text-format data coming from Zabbix via the Zabbix Datasource Plugin. Specifically, I wanted to display this data using the table visualization in Grafana. While searching the forums, I also found several people with the same concern. That’s when I managed to achieve this display and I want to share it with everyone.
The crucial point for this to work is that the text needs to be formatted in JSON, as in the following example.
[{"itemid":"46154","clock":"1756092766","value":"0.033133333333333334"},
{"itemid":"46154","clock":"1756092756","value":"0.03376666666666667"},
{"itemid":"46154","clock":"1756092716","value":"0.033466666666666665"}]
After that, we will move on to the transformations in Grafana. By following this sequence of transformations, you will get a clean visualization with multiple filtering possibilities.
Transform data.
1 - Extract fields > Format (auto)
2 - Reduce > Mode (Series to rows) > Last
3 - Extract fields (yes, again) > Format (key+value pairs)
The final result is as follows, every piece of data in its row and column separately:
Apologies if there is already a post in the community explaining this method, but in my research, I didn’t find any that were objective and clear.
Thanks to all.