Arcade script issue

[CallahanWalker]

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?

[jcarlson]

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.

[JenniferAcunto · Accepted solution]

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.

[CallahanWalker]

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

[JenniferAcunto]

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

[CallahanWalker]

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.

[JenniferAcunto · Accepted solution]

Add a data source filter.

[CallahanWalker]

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?

[JenniferAcunto]

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.

[j1assa]

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?