Vizualize sql data on Grafana graph

Hi,

I am using Grafana 7.1.3
I would like to vizualize these data on Grafana graph but they display like below. There are coming from zabbix. In Zabbix I am using specific SQL query to achieve these result.

Timestamp	                Value
2022-03-15 14:54:15	  {"data":[{"{#A_METHOD_GROUP_BY}":"x1","{#CONP}":"3","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"x1_g","{#CONP}":"1","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"pe","{#CONP}":"2","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"ya","{#CONP}":"3","{#TIMEIN}":"6"}]}
2022-03-15 14:39:13	  {"data":[{"{#A_METHOD_GROUP_BY}":"x1","{#CONP}":"3","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"x1_g","{#CONP}":"1","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"pe","{#CONP}":"2","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"ya","{#CONP}":"3","{#TIMEIN}":"6"}]}
2022-03-15 14:24:16	  {"data":[{"{#A_METHOD_GROUP_BY}":"x1","{#CONP}":"3","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"x1_g","{#CONP}":"1","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"pe","{#CONP}":"2","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"ya","{#CONP}":"3","{#TIMEIN}":"6"}]}
2022-03-15 14:09:25	  {"data":[{"{#A_METHOD_GROUP_BY}":"x1","{#CONP}":"3","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"x1_g","{#CONP}":"1","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"pe","{#CONP}":"2","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"ya","{#CONP}":"3","{#TIMEIN}":"6"}]}
2022-03-15 13:54:42	  {"data":[{"{#A_METHOD_GROUP_BY}":"x1","{#CONP}":"3","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"x1_g","{#CONP}":"1","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"pe","{#CONP}":"2","{#TIMEIN}":"4"},{"{#A_METHOD_GROUP_BY}":"ya","{#CONP}":"3","{#TIMEIN}":"6"}]}

Can you help me with this? Should I use regex to filter these data?

welcome to the :grafana: forum, @thegrafanauser

Can you inspect your raw request and response?