Data Expression Returning Empty
I have tried this 8 ways to Sunday and I can't get it to work. This is the furthest I have gotten, and I am hoping someone can help me get the rest of the way. We are operating version 10.9.1 on our portal server.
I am trying to create a data expression for a dashboard that is fed by Survey 123. I am accessing the "Results" layer, and I own it. Editing is enabled, but Sync is disabled. All I really want to do is add 5 fields to the original and calculate them based on the incident date, I need to have the ability to aggregate on Year, Month, Day of Week, Hour and Quarter. The calculations appear to be working, but the output comes out with a list of empty fields.
here is my code:
var portal =Portal('https://egis-sige.rcmp-grc.gc.ca/portal');
var fs = FeatureSetByPortalItem(portal, '6324abd8c2744757871fe4ee85272666',1,['incident_date', 'duration', 'district', 'detachment','tasks', 'foi', 'incident_summary','incident_no'],false);
var s = Schema(fs)
var sFldCount = Count(s.fields)
var newFldCount = sFldCount
s.fields[newFldCount] = {alias: 'Year', defaultValue: null, editable: true, length: 5, name: 'occ_year', type: 'esriFieldTypeString'}
s.fields[newFldCount+1] = {alias: 'Month', defaultValue: null, editable: true, length: 25, name: 'occ_month', type: 'esriFieldTypeString'}
s.fields[newFldCount+2] = {alias: 'Day of Week', defaultValue: null, editable: true, length: 25, name: 'dow', type: 'esriFieldTypeString'}
s.fields[newFldCount+3] = {alias: 'Hour', defaultValue: null, editable: true, length: 5, name: 'occ_hour', type: 'esriFieldTypeString'}
s.fields[newFldCount+4] = {alias: 'Quarter', defaultValue: null, editable: true, length: 5, name: 'quarter', type: 'esriFieldTypeString'}
var returnFS = {
fields: s.fields,
geometryType: '',
features:[],
}
console(returnFS)
var index = 0;
for (var f in fs) {
returnFS.features[index] = {
'fields': {
'incident_date': f.incident_date,
'duration': f.duration,
'district': f.district,
'detachment': f.detachment,
'tasks': f.tasks,
'foi': f.foi,
'incident_summary': f.incident_summary,
'incident_no': f.incident_no,
'occ_year': Text(f.incident_date,"yyyy"),
'occ_month': Text(f.incident_date, "MMMM"),
'dow': Text(f.incident_date, "dddd"),
'occ_hour': Text(f.incident_date, "HH"),
'quarter': IIF(ISOMonth(f.incident_date)>9, "Q3", IIF(ISOMonth(f.incident_date)>6,"Q2",IIF(ISOMonth(f.incident_date)>3,"Q1","Q4")))
}
}
index++; };
console(returnFS)
return FeatureSet(Text(returnFS))I have tried the above, I have tried populating a "features" array and feeding that to the dictionary, and I have tried the Push() function in a For Loop to push a feature into the Features element of the dictionary. this is the only version that pretends to work, the features are going in/coming out, but not with all their attributes:
Thank you!!
