topic Re: Attempting to create a data expression, not sure why it won't work in ArcGIS Dashboards Questions

Attempting to create a data expression, not sure why it won't work

BBooker — Wed, 28 May 2025 20:12:40 GMT

I am attempting to get the day counts for incidents that occurred on that date. Really just need it to show how many collectively happened on Monday, Tuesday, etc.. It would also be nice to see if they happened after working hours. This is my code so far:

var portal = Portal("https://www.arcgis.com/");

var fs = FeatureSetByPortalItem(

portal,

"b7a7144cda9046a5bfc6b36fa88e0477",

['DateTime'],

false

);

var dayCounts = {

"0": 0,

"1": 0,

"2": 0,

"3": 0,

"4": 0,

"5": 0,

"6": 0

};

for (var f in fs) {

var dateVal = f['DateTime'];

if (!IsEmpty(dateVal)) {

var day = Weekday(dateVal) - 1;

if (HasKey(dayCounts, day)) {

dayCounts[day] += 1;

}

var outDict = {

fields: [

{ name: "Day", alias: "Day of Week", type: "esriFieldTypeInteger" },

{ name: "Count", alias: "Incident Count", type: "esriFieldTypeInteger" }

geometryType: "",

features: []

};

// Add the results as features

for (var k in dayCounts) {

Push(outDict.features, {

attributes: {

Day: Number(k),

Count: dayCounts[k]

}

});

};

return FeatureSet(Text(outDict));

Re: Attempting to create a data expression, not sure why it won't work

KenBuja — Thu, 29 May 2025 12:44:47 GMT

You just need to convert day to a Text string to use it in the HasKey function (line 19).

Note that your original line was "Weekday(dateVal) - 1", which is incorrect. The Weekday function returns the day using values ranging from 0 (Sunday) to 6 (Saturday).

This also only counts that incidents that are outside the hours of 9 am and 5 pm (line 18)

Re: Attempting to create a data expression, not sure why it won't work

BBooker — Thu, 29 May 2025 16:49:55 GMT

Thank you, I'll try it out soon!