# Create Table Vizualization as text to json data from Zabbix Datasource

**URL:** <https://community.grafana.com/t/create-table-vizualization-as-text-to-json-data-from-zabbix-datasource/156699>\
**Category:** Dashboards\
**Tags:** json, plugins, table-view\
**Created:** [August 25, 2025, 3:54am UTC](https://community.grafana.com/t/create-table-vizualization-as-text-to-json-data-from-zabbix-datasource/156699 "2025-08-25T03:54:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lucasmgiacomini](https://avatars.discourse-cdn.com/v4/letter/l/bcef8e/32.png) [@lucasmgiacomini](https://community.grafana.com/u/lucasmgiacomini)\
**Post date:** [August 25, 2025, 3:54am UTC](https://community.grafana.com/t/create-table-vizualization-as-text-to-json-data-from-zabbix-datasource/156699/1 "2025-08-25T03:54:32Z")

</div>

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.

```json
[{"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)**

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/5/0/50cb351bed8e0f4c5f08e6ca3798dde57c03ae78.png)

The final result is as follows, every piece of data in its row and column separately:

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/4/c/4ca6f789741d213d4010a3195306b86a23c432da.png)

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.
