Hello guys,
I'm using arcade to group a feature class based on some columns to view it on table widget in dashboard. The script running successfully and shown on the table widget. However, there is "Unable to Execute Arcade script" warning on the table.
I've already make sure the script returns a featureset.
And this is the script:
var portal_ = Portal('https://jtii.maps.arcgis.com/');
var fs = FeatureSetByPortalItem(
portal_,
'ea084777332241d28faba60aaac3ef6d',
1,
['CUSTOMER_ID','CUSTOMER_NAME','TAHUN','BULAN','MINGGU','TAHUN_MINGGUAN','CUSTOMER_CATEGORY_ID_2','Segment','Square_Segmentation','Family_Brand','region','area_cluster','work_place','Dropsize_Pack', 'Volume_Industry', 'MBO_SPM', 'A_Mild'],
False);
var bosnet_sum = GroupBy(fs,
[{ name: 'CUSTOMER_ID', expression: 'CUSTOMER_ID'},
{ name: 'CUSTOMER_NAME', expression: 'CUSTOMER_NAME'},
{ name: 'TAHUN', expression: 'TAHUN'},
{ name: 'BULAN', expression: 'BULAN'},
{ name: 'MINGGU', expression: 'MINGGU'},
{ name: 'TAHUN_MINGGUAN', expression: 'TAHUN_MINGGUAN'},
{ name: 'CUSTOMER_CATEGORY_ID_2', expression: 'CUSTOMER_CATEGORY_ID_2'},
{ name: 'Segment', expression: 'Segment'},
{ name: 'Family_Brand', expression: 'Family_Brand'},
{ name: 'Square_Segmentation', expression: 'Square_Segmentation'},
{ name: 'region', expression: 'region'},
{ name: 'area_cluster', expression: 'area_cluster'},
{ name: 'work_place', expression: 'work_place'}
],
[{ name: 'Dropsize_Camel', expression: 'Dropsize_Pack', statistic: 'SUM'},
{ name: 'Volume_Industry', expression: 'Volume_Industry', statistic: 'AVG'},
{ name: 'MBO_SPM', expression: 'MBO_SPM', statistic: 'AVG'},
{ name: 'A_Mild', expression: 'A_Mild', statistic: 'AVG'}
]);
return bosnet_sum
Anyone got any clue why this is happened?
Regards,
Naufal