How to convert json data

Grafana Dashboards
1

I get this json message via api call and I don’t have any idea how to plot this as bar chart. I have 8 different timestamps as string and 4 different series of data and the corresponding data. I’m importing via infinity.

To clarify it. I want the labels either to be ploted as date or as a category, that does not make a difference to me.

[
	{
		"labels": [
			"15:00",
			"15:15",
			"15:30",
			"15:45",
			"16:00",
			"16:15",
			"16:30",
			"16:45"
		],
		"series": [
			"Verbrauch",
			"Produktion",
			"Netzbezug",
			"Rückspeisung"
		],
		"data": [
			[
				-145.5,
				-193.1,
				-172,
				-225.5,
				-242.4,
				-134.9,
				-457.5,
				-616.5
			],
			[
				95.6,
				280.3,
				329.5,
				770.1,
				525.3,
				790.4,
				875.1,
				869
			],
			[
				60.4,
				5.7,
				35.8,
				0,
				0,
				0,
				41.1,
				76.2
			],
			[
				-10.5,
				-92.9,
				-193.3,
				-544.6,
				-282.9,
				-655.5,
				-458.8,
				-328.6
			]
		]
	}
]
3

look at this jsonata approach to map data points so that the final product looks like what you want

https://try.jsonata.org/q2ppFKq7i

4

Thanks alot.

https://try.jsonata.org/fX29nc9N8

2 Likes