topic Re: Custom Arcade Data source returns fewer records than it gets in ArcGIS Dashboards Questions

Custom Arcade Data source returns fewer records than it gets

JCGuarneri — Fri, 20 Sep 2024 16:30:50 GMT

I'm having trouble with an Arcade data source that I want to use in a dashboard (Enterprise 11.1). The goal is to take some inspections in Cityworks and sort them into bins based on what year in a 5-year cycle they fall in, to help managers rebalance them.

The problem is, the expression returns fewer values than it pulls in initially. Even more perplexing, the exact number of records returned each time is different:

Here's the code I'm using (server names changed to protect the innocent). Is there something I'm missing in the code that could cause that?

Re: Custom Arcade Data source returns fewer records than it gets

KenBuja — Fri, 20 Sep 2024 17:13:49 GMT

It's because you set the InspectionID field in the dictionary as an esriFieldTypeOID. In testing with my data, if I use an InspectionID field that has unique values, I get the correct number of records. If I use a field without unique records, it only returns the number of unique records. Changing the field type to esriFieldTypeInteger returns all the records, regardless of whether the value are unique or not.

var cycleYears = { 'fields': [{'name':'InspectionID', 'type': 'esriFieldTypeInteger'}, {'name':'ShopDescription', 'type': 'esriFieldTypeString'}, {'name':'District', 'type': 'esriFieldTypeString'}, {'name':'CycleYear','type': 'esriFieldTypeDouble'}], 'geometryType': '', 'features': [] }

Re: Custom Arcade Data source returns fewer records than it gets

JCGuarneri — Fri, 20 Sep 2024 17:31:19 GMT

Ah, that worked! Thank you. Theoretically, those are all unique. But I'm happy that works. Exposed another thing I need to sort out, but this get's me very close to the finish line.

Re: Custom Arcade Data source returns fewer records than it gets

KenBuja — Fri, 20 Sep 2024 20:05:03 GMT

With some more testing, I found a way to get the result faster, using the GroupBy function. Give this a try

Re: Custom Arcade Data source returns fewer records than it gets

JCGuarneri — Fri, 20 Sep 2024 20:32:30 GMT

You're not kidding about that being faster! I had to make a couple minor modifications, but it is returning the correct number of values for each cycle year. I can't seem to get it to populate values correctly for ShopDescription and District (returns NaN), but I was considering splitting out those categories at the Cityworks URL side, anyway.

Thank you for your help!