topic Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data. in ArcGIS Dashboards Questions

Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

ZacStanleyNPS — Fri, 24 May 2024 14:32:59 GMT

Hello,

I'm hoping what I have is simple issue someone can see easier than me. I'm simply trying to aggregate trail names and sum their segment lengths to display in a dashboard list:

var portal = Portal('https://www.arcgis.com/'); var fs = FeatureSetByPortalItem(Portal, '7b1fb95ab77f40bf8aa09c8b59045449', 0, [ 'TRLNAME', 'LengthMiles' ], False //don’t include geometry ); return GroupBy(fs, 'TRLNAME', { name: 'LengthMilesSum', expression: 'LengthMiles', statistic: 'SUM' });

The expression as is returns the error: Test execution error: Aggregation field not found. Verify test data.

I've tested enough to know that the error is in the group by function. Would love any help / tips.

Thanks!

Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

jcarlson — Fri, 24 May 2024 14:46:36 GMT

When I look for that AGOL item, it's China prefecture demographics. Definitely no LengthMiles attribute on it.

https://www.arcgis.com/home/item.html?id=7b1fb95ab77f40bf8aa09c8b59045449&view=list&sortOrder=desc&sortField=defaultFSOrder#data

Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

ZacStanleyNPS — Fri, 24 May 2024 14:54:03 GMT

Well that's embarrassing. Correct Item ID now returns: Test execution error: Unknown Error. Verify test data.

var portal = Portal('https://www.arcgis.com/'); var fs = FeatureSetByPortalItem(Portal, '6a4eb769a1974476a3794a31054ddc63', 0, [ 'TRLNAME', 'LengthMiles' ], False //don’t include geometry ); return GroupBy(fs, 'TRLNAME', { name: 'LengthMilesSum', expression: 'LengthMiles', statistic: 'SUM' });

Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

jcarlson — Fri, 24 May 2024 15:03:35 GMT

I don't have access to that particular item, but I see you're referencing Portal (with a capital p) after assigning the variable portal with a lower-case p. Can you change line 2 to use lower case and see what happens?

Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

ZacStanleyNPS — Fri, 24 May 2024 15:06:29 GMT

Just caught that error too - I shared the item publicly if that helps. Thanks!

Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

jcarlson — Fri, 24 May 2024 15:32:11 GMT

There it is! You can see it in the URL:

sublayer=10

Change that to a 10 and it works!

Re: Arcade GroupBy Function Error: Aggregation field not found. Verify test data.

ZacStanleyNPS — Fri, 24 May 2024 15:36:35 GMT

Right! It's a feature set! TY!