Grouping by value and its children in a single column

Grafana Dashboards
1

Hi!
I am using Json API as datasource. I am getting organization titles from api: $.result.nodes[*].children[*].title, each organization has an array of banks as the children field, so I can get banks titles by $.result.nodes[*].children[*].children[*].title. Also, each bank has a value field. So, is it possible to group by organization title and its banks in one column and values in another column. That’s what I mean:

image
image900×187 4.01 KB

Is this possible, and if so, how can I achieve it? Thanks!

2

yes it is possible, again jsonata is your friend.

3

I understand how to display organization title and its banks in different columns. But I don’t know how to display organization title, then its banks in one column

5

OMG THANKS A LOT, this is exactly what I was looking for

1 Like