topic Re: Arcade for Chart in ArcGIS Online Questions

Arcade for Chart

Jon-PaulMcCool — Mon, 21 Feb 2022 13:29:24 GMT

If a layer has a numeric attribute that is stored as text, but I'd like to use that attribute to create charts and need it to be numeric, is there a way to create an expression to alter it to a number to use it for a chart?

I can readily create an expression if altering the symbology/style, but I see no way to essentially create a new attribute using Arcade for use in a chart.

Using current map viewer.

Re: Arcade for Chart

jcarlson — Mon, 21 Feb 2022 14:34:39 GMT

On the configure popup menu:

Create a custom popup expression

Number($feature['your_numeric_string_field'])

The new expression will be available in your chart settings:

Re: Arcade for Chart

Jon-PaulMcCool — Mon, 28 Feb 2022 16:35:56 GMT

Thank you very much Josh, but this only allows the use of the attribute in a popup chart (as far as I can tell). I'm trying to be able to use an expression attribute in a layer level chart.

For example, using this earthquake data. If I wanted to use this expression

round($feature.mag,0)

but then to create a histogram of rounded magnitudes for the layer using Configure Charts, my expression is not available despite being a number.

That is just an example. I've come across other attributes stored as text, that I could pass as number for use in popups, but no expression I make seems to be available for use in the Configure Charts section for use in creating layer charts (or master level charts? ... charts not in popups).