Date field returns empty in Arcade expression

ZenMasterZeke — Mon, 01 May 2023 16:45:29 GMT

I have a data expression for a dashboard indicator (below). The problem is that the 'created_date' field returns no values. I have seen the thread here, but can't see where I'm going wrong. The date does show up in the Console as either:

Script: attributes: {sample: po['sample_id_post_pfas'],created: Number(po['created_date'])}:
Console: {"attributes":{"sample":"123-A-456","created":1678124975146}}

Script: attributes: {sample: po['sample_id_post_pfas'],created: po['created_date']}:
Console: {"attributes":{"sample":"123-A-456","created":"2023-03-06T17:49:35.146Z"}}

The basic idea is that there are 700+ records, each of which can have null or values in any of 7 id fields, although only checking 3 here. My goal is to get a count of all non-null ids, along with the date created (same date for all ids in a single record). If I have 700 records, for example, there might be 900 samples. I've got the count, but want to be able to filter by date in the dashboard.

Any idea what I'm missing? Thanks.

Re: Date field returns empty in Arcade expression

JohannesLindner — Mon, 01 May 2023 20:16:50 GMT

You named the field "created_date" (line 52), but in the features, you call it "created" (lines 23. 33, 34). They have to be the same.

Re: Date field returns empty in Arcade expression

ZenMasterZeke — Mon, 01 May 2023 20:58:44 GMT

Thanks @JohannesLindner . Obvious in hindsight 🙃

topic Date field returns empty in Arcade expression in ArcGIS Dashboards Questions

Date field returns empty in Arcade expression

Re: Date field returns empty in Arcade expression

Re: Date field returns empty in Arcade expression