topic Failed to Execute Arcade Message on Table in ArcGIS Dashboards Questions

topic Failed to Execute Arcade Message on Table in ArcGIS Dashboards Questions https://community.esri.com/t5/arcgis-dashboards-questions/failed-to-execute-arcade-message-on-table/m-p/1364684#M8901 <P>Hello guys,<BR /><BR />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.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MuhammadNaufalIhsan_0-1703735620303.png" style="width: 635px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/90063iC04BB0AC8D0BE12E/image-dimensions/635x235?v=v2" width="635" height="235" role="button" title="MuhammadNaufalIhsan_0-1703735620303.png" alt="MuhammadNaufalIhsan_0-1703735620303.png" /></span></P><P> </P><P>I've already make sure the script returns a featureset.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MuhammadNaufalIhsan_1-1703735721257.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/90064i21F7798BE326393D/image-size/medium?v=v2&px=400" role="button" title="MuhammadNaufalIhsan_1-1703735721257.png" alt="MuhammadNaufalIhsan_1-1703735721257.png" /></span></P><P>And this is the script:</P><LI-CODE lang="javascript">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</LI-CODE><P> Anyone got any clue why this is happened?<BR /><BR />Regards,<BR />Naufal</P> Thu, 28 Dec 2023 03:57:42 GMT MuhammadNaufalIhsan 2023-12-28T03:57:42Z Failed to Execute Arcade Message on Table https://community.esri.com/t5/arcgis-dashboards-questions/failed-to-execute-arcade-message-on-table/m-p/1364684#M8901 <P>Hello guys,<BR /><BR />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.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MuhammadNaufalIhsan_0-1703735620303.png" style="width: 635px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/90063iC04BB0AC8D0BE12E/image-dimensions/635x235?v=v2" width="635" height="235" role="button" title="MuhammadNaufalIhsan_0-1703735620303.png" alt="MuhammadNaufalIhsan_0-1703735620303.png" /></span></P><P> </P><P>I've already make sure the script returns a featureset.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MuhammadNaufalIhsan_1-1703735721257.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/90064i21F7798BE326393D/image-size/medium?v=v2&px=400" role="button" title="MuhammadNaufalIhsan_1-1703735721257.png" alt="MuhammadNaufalIhsan_1-1703735721257.png" /></span></P><P>And this is the script:</P><LI-CODE lang="javascript">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</LI-CODE><P> Anyone got any clue why this is happened?<BR /><BR />Regards,<BR />Naufal</P> Thu, 28 Dec 2023 03:57:42 GMT https://community.esri.com/t5/arcgis-dashboards-questions/failed-to-execute-arcade-message-on-table/m-p/1364684#M8901 MuhammadNaufalIhsan 2023-12-28T03:57:42Z