Data Expression Returning Empty

EBurridge — Tue, 22 Aug 2023 21:34:47 GMT

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:

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!!

Re: Data Expression Returning Empty

JohannesLindner — Tue, 22 Aug 2023 22:28:58 GMT

Replace line 25 with this:

'incident_date': Number(f.incident_date),

In previous Arcade versions, Date values had to be submitted as Numbers. This problem is fixed in AGOL and will probably be fixed in Enterprise 11.2

Re: Data Expression Returning Empty

EBurridge — Wed, 23 Aug 2023 21:06:31 GMT

Thank you @JohannesLinder! I changed just that row, and nothing changed about my output - it is all the same, about 2000 features with not a single populated attribute.

I then changed the field definitions in the dictionary to make the incident_date a numeric field, but that also didn't work.

Any other suggestions?

topic Re: Data Expression Returning Empty in ArcGIS Dashboards Questions

Data Expression Returning Empty

Re: Data Expression Returning Empty

Re: Data Expression Returning Empty