Dashboard Arcade Group Layers
First of all, note the code sample button on here. It can really help others read and understand your expressions.
Second, point is an Arcade function, so try using a different name for that FeatureSet.
Third, in GroupBy, if your grouping and statistics parameters only have a single item, you don't need to put them inside an array.
Fourth, your GroupBy expressions don't match the requested field names. This is not necessarily a problem, but know that the expression you're supplying must match a field name in the service. You don't have to have a field called Point_CatCode28 in your requested list of fields, but it needs to be in the service, otherwise the expression won't evaluate.
Fifth, and this is where you may be getting errors, I think: you're calling the SUM function on individual features, but the function is expecting a FeatureSet, an array, or a list. Calling it on a feature won't work. Also, you're already summing this field in your GroupBy functions. You can replace this with the name of the attribute you created in the GroupBy statement.
count_of_found: p['CatCode28_poly']
If you're trying to get a per-type sum, keep in mind that once your data expression comes into the dashboard, many of the dashboard's own widgets can handle additional grouping and aggregating for you.
Finally, and this could also be the source of the error, your feature attributes objects don't match the fields in your combinedDict. If your combinedDict has fields CatCode28 and count_of_found, then you must have corresponding attributes in your features, otherwise these fields will be null. If you really want your "type" attributes to come through in the output, you need a field for that, too.
It's hard to know exactly how to re-write this without more information about the data and what exactly you're envisioning to come out of it, but here's a version of your expression with some of these changes in place.
var portal = Portal('PORTAL_URL');
var pt = GroupBy(
FeatureSetByPortalItem(
portal,
'FEATURE_ID',
0,
['RBU','CatCode28'],
false
),
'RBU',
{
name: 'CatCode28_point',
expression: 'Point_CatCode28',
statistic: 'SUM'
}
);
var ln = GroupBy(
FeatureSetByPortalItem(
portal,
'eba1d0d180a0419499566e4aa1336eea',
0,
['RBU','CatCode28'],
false
),
'RBU',
{
name: 'CatCode28_line',
expression: 'Line_CatCode28',
statistic: 'SUM'
}
);
var poly = GroupBy(
FeatureSetByPortalItem(
portal,
'111b954c606045e18180d507fcc40aef',
0,
['RBU','CatCode28'],
false
),
'RBU',
{
name: 'CatCode28_poly',
expression: 'Poly_CatCode28',
statistic: 'SUM'
}
);
// Create empty array for features, feat object to populate array
var features = [];
var feat;
// Loop through each of the three FeatureSets and populate feature array.
for (var p in point) {
feat = {
attributes: {
geom_type: 'Points',
RBU: p['RBU'],
count_of_found: p['CatCode28_point']
},
};
Push(features, feat);
}
for (var l in line) {
feat = {
attributes: {
geom_type: 'Line',
RBU: l['RBU'],
count_of_found: l['CatCode28_line']
}
};
Push(features, feat);
}
for (var g in polygon) {
feat = {
attributes: {
geom_type: 'Polygon',
RBU: g['RBU'],
count_of_found: g['CatCode28_poly'],
}
};
Push(features, feat);
};
var combinedDict = {
fields: [
{name: 'geom_type', type: 'esriFieldTypeString'},
{name: 'RBU', type: 'esriFieldTypeString' },
{name: 'count_of_found', type: 'esriFieldTypeInteger' }
],
geometryType: '',
features: features
};
// Return dictionary cast as a feature set
return FeatureSet(Text(combinedDict));
