Want to show json data row by row. But it is showing single row

Grafana Table Panel
1

HI Team,

We are trying to show values as table format based on JSON. We are getting all the values in same row but we are expecting row by row values. Could you please suggest how to solve that issue.

Json Data:

[
	{
		"result": "succeeded",
		"name": "Initialize job",
		"state": "completed"
	},
	{
		"result": "succeeded",
		"name": "Checkout gitleaks-config@main to s/gitleaks-config",
		"state": "completed"
	},
	{
		"result": "succeeded",
		"name": "Checkout 14819-CD-ansible-testing@release/metrics-test to s/14819-CD-ansible-testing",
		"state": "completed"
	},
	{
		"result": "succeeded",
		"name": "Finalize Job",
		"state": "completed"
	}
]

Table Showing same row:

image
image1423×222 43.6 KB

Grafana version : v9.1.0

  • What happened?
    It is showing same row all the values fron json data.

  • What did you expect to happen?
    It should be showed row by row

2

JSON Data you provided is processed correctly by Infinity plugin:

infinity
infinity975×911 78.9 KB

3

Thanks ebabeshko.
As of now we using open search data source so how can i pass that values to infinity plugin which i received from open search
Currently I am using Grafana version : v9.1.0 so this version support Infinity plugin.

image
image1449×498 51.9 KB

4

is open search endpoint url:9200?

5

No,we are using ***es.amazonaws.com.

6

provide that endpoint to the infinity plugin, the Source URL section

image

7

Thanks @yosiasz

Another query is “We are using opensearch datasource so we need to display array of objects in pie chart.”

Sample :

Names : [{
“userone”: 3
},
{
“usertwo”:2
},
{
“userone”: 2
}]

we are expecting output like this

Name Count
userone 5
usertwo 2

NOTE: I already raised this query separate but i haven’t got any response “How to display array of objects in bar or pie chart for opensearch datasource”