Summarize Nested Json

1

I have been working with tm-http-request to fetch a json dataset and I have been mostly using jsonget to populate my display.

image
image1529×628 99.8 KB

However, I have a nested subsection of the json dataset that I would really like to summarize as a count of Owner_Type.

I can get to the data though two filters, but I have no clue how/if I can get a summary count.

<$set name="jsondata" value={{GW2MatchRaw}}>

	<$list filter="[<jsondata>jsonindexes[maps]]" variable=mapID>
		<$list filter="[<jsondata>jsonindexes[maps],<mapID>,[objectives]]" variable=n>
            <<mapID>>_<<n>>: 
			<$text text= {{{[<jsondata>jsonget[maps],<mapID>,[objectives],<n>,[owner]]}}} />
			<$text text= {{{[<jsondata>jsonget[maps],<mapID>,[objectives],<n>,[type]]}}} /> <br>
		</$list>
	</$list>
</$set>

The above nested list filters provide the correct data:

1_0: Blue Camp
1_1: Red Ruins
1_2: Blue Keep
1_3: Blue Spawn
1_4: Red Camp
1_5: Red Keep
1_6: Red Ruins
1_7: Red Camp
1_8: Green Tower
1_9: Red Keep
...

However, I lack the skill to combine this into filter[ ]/match[ ]/count[ ]/magic[ ] logic to end up with something along the lines of:

image
image312×102 1.52 KB

Is this possible? guidance/help appreciated.

2

It would help if you could post some JSON data that we can use to test solutions with.

-e

3

Here is an example GW2MatchRaw tiddler fetched based on the select dropdown and refresh button:

GW2MatchRaw.tid (75.0 KB)