topic Re: Dashboard - Arcade calculation from 2 Layers in ArcGIS Dashboards Questions

Dashboard - Arcade calculation from 2 Layers

JackG — Thu, 12 Oct 2023 20:26:18 GMT

Hi, I am trying to create a simple calculation which works in the Arcade Expression, but says its unable to execute within a Dashboard Element (Indicator).

In Dashboards, I add Element > Indicator > select the 'New Data Expression' enter the code and its valid, but when i click 'Done' i get 'Unable to execute Arcade script'

Arcade_works.PNG

AIRS_Unabletoexecute.jpg

Code:

//***Visitors***//

var OfficeVisitors = FeatureSetByPortalItem (Portal('portalURL'), 'layerID', 0, ['*'], false);

var Visitors = Sum(OfficeVisitors, 'visit_cnt');

//***Incident***//

var Incidents = FeatureSetByPortalItem (Portal('portalURL'), 'layerID', 0, ['*'], false);

var Total_Incidents = Count(Incidents);

//***Incidents 100K Visitors***//

var IncidentsPer100K = (Incidents/Visitors)*100000

return IncidentsPer100K

Thank You,

Jack

Re: Dashboard - Arcade calculation from 2 Layers

jcarlson — Thu, 12 Oct 2023 20:56:26 GMT

Data Expressions have to return a FeatureSet. If you really just want that single number, you can try this:

//***Visitors***// var OfficeVisitors = FeatureSetByPortalItem (Portal('portalURL'), 'layerID', 0, ['*'], false); var Visitors = Sum(OfficeVisitors, 'visit_cnt'); //***Incident***// var Incidents = FeatureSetByPortalItem (Portal('portalURL'), 'layerID', 0, ['*'], false); var Total_Incidents = Count(Incidents); //***Incidents 100K Visitors***// var IncidentsPer100K = (Incidents/Visitors)*100000 var out_dict = { fields: [ {name: 'incidentsPer100K', type: 'esriFieldTypeDouble'} ], geometryType: '', features: [ { attributes: { incidentsPer100K: IncidentsPer100K }} ] } return FeatureSet(out_dict)

But really, I think you could do this with a reference value as well.

Re: Dashboard - Arcade calculation from 2 Layers

JackG — Fri, 13 Oct 2023 14:18:28 GMT

For the FeatureSet return, you have to use 'text' as well to get results. FeatureSet(Text (out_dict)) worked.

Do you or know how i can add a date filter to the portalitem? I want to show visitor counts to say where 'day_dt' >= '01/01/2016' I assume I have to add the filter around the SetPortalitem based on a few other posts but can't seem to get it working right.

Then ultimately i wanted to somehow display the incidents per 100K visitors for each month somehow... Right now the visitor table i have goes back to 2004 and the incident table is from 2016. So i need to at least filter the visitor counts to "is or is after" 01/01/2016".

Then I would somehow like to groupby month somehow of incidents per 100K visitors per month

output to be:

{ attributes: { Jan 2016: IncidentsPer100K} { Feb 2016: IncidentsPer100K} { March 2016: IncidentsPer100K} { Apr 2016: IncidentsPer100K} {etc: etc}}