topic Re: Arcade script issue in ArcGIS Online Questions

Arcade script issue

CallahanWalker — Fri, 07 Jun 2024 21:32:07 GMT

I am creating a dashboard on ARCGIS Online and am wanting to add an indicator. The indicator I want to create requires me to create a new data expression. I want it to show the Call Percentage, which would be the total count of the "Code" field/ total count of the "Dispositions" field. The majority of the data in the dispositions field is empty if that helps. I figured out how to run it and get the correct output, but whenever I press Done it says that "Unable to execute Arcade script". It looks like I need to return a FeatureSet instead of text, but I run into even more problems when I try to return a FeatureSet it says"error: Execution error - Cannot access value using a key of this type. Verify test data". Can anyone help me with this?

Re: Arcade script issue

jcarlson — Sat, 08 Jun 2024 03:04:08 GMT

Sharing your expression would be helpful in figuring it out. It sounds like a simple enough problem, but it's hard to know exactly what's wrong without seeing it.

Re: Arcade script issue

JenniferAcunto — Mon, 10 Jun 2024 11:37:45 GMT

From what you've described, you don't need a Data Expression. Make the Code value your normal indicator data value, use the Reference field to grab the Dispositions value, and then display the {ratio} in the indicator display. Similar to the first example that sums two fields, but you don't even need to get into the Advanced Formatting section Dashboards That Pop: Indicator Hacks.

Re: Arcade script issue

CallahanWalker — Mon, 10 Jun 2024 20:24:24 GMT

Thank you so much for this. Can I somehow make the indicator update as I zoom in and out of the map?

Re: Arcade script issue

CallahanWalker — Mon, 10 Jun 2024 20:43:08 GMT

Also, if I want to create indicators based on a specific value in a field, can I do so this way? For instance I want to reference only the dispositions where the value is "SOLD" in an equation.

Re: Arcade script issue

JenniferAcunto — Tue, 11 Jun 2024 11:56:50 GMT

Add a data source filter.

Re: Arcade script issue

JenniferAcunto — Tue, 11 Jun 2024 11:59:33 GMT

Add a Map Action to the map and target your indicator. You will probably want to target both the value and reference value.

Re: Arcade script issue

CallahanWalker — Tue, 11 Jun 2024 15:16:06 GMT

Thank you so much for the help. If I want to use division instead of a ratio or percentage, would I have to use advanced formatting?

Re: Arcade script issue

JenniferAcunto — Wed, 12 Jun 2024 17:08:19 GMT

Ratio is just the value divided by the reference but if you wanted some other math, then yes you would set that up using the Advanced Formatting.

Re: Arcade script issue

j1assa — Sat, 15 Jun 2024 09:07:08 GMT