Failed to Execute Arcade Message on Table

342
0
12-27-2023 07:57 PM
Labels (1)
MuhammadNaufalIhsan
New Contributor III

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.

MuhammadNaufalIhsan_0-1703735620303.png

 

I've already make sure the script returns a featureset.

MuhammadNaufalIhsan_1-1703735721257.png

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

0 Replies