Arcade Data Expression - GroupBy on Non Hosted Feature Layer

AndrewKesterton

Hi dashboard community, 

I'm trying out Arcade data expressions in ArcGIS Enterprise 10.9.1 (so Arcade 1.15). 

When looking for statistics/summary values with the GroupBy function on a non-hosted feature layer, the data expression doesn't seem to parse the results of the statistics.  

 

 

 

var portal = Portal('https://myportalurl/portal');
var fs = FeatureSetByPortalItem(
    portal,
    'b10d26459a3e415f856a8310da14accc',
    1,
    [
        'parentrowid',
        'quantity'
    ],
    false
);
return GroupBy(fs, ['parentrowid'], 
[{name: 'count_features', expression: 'quantity', statistic: 'SUM' }]);

 

 

 

 

Returns:

The same data expression against a hosted feature layer works correctly.  The feature layers support statistics, and I see them returned correctly by the rest service, but they dont appear in my expression. 

Is there a known limitation using Arcade with these feature services? 

Thanks,

Andrew 

AndrewKesterton

Hi @MohammedZaki , no - I came to the same conclusion that this is a bug but wasn't able to have it logged.  

Good to know it works on SQL Server so the bug report can be targetted. 

Andrew