topic Re: how can I make label using arcade that has multiple values in ArcGIS Online Questions

how can I make label using arcade that has multiple values

ScottShenberger — Wed, 21 Aug 2019 21:48:12 GMT

I am trying to create an arcade expression that will pull only part of an attribute field. We track multiple document numbers in a field called DocumentNumber. Each document is separated by an !. I want to create a label from just the first document number. For example, I can have a document number field that looks like PN 123-4567!FN 1234 or FN 4567!PN 7654-123 (although document numbers vary by length depending on type) I would like to create a label based on the first value of the document number field which is where I am struggling

Thank you

Re: how can I make label using arcade that has multiple values

XanderBakker — Wed, 21 Aug 2019 22:03:00 GMT

Hi Scott Shenberger ,

Could you try this:

return Split($feature.DocumentNumber, '!')[0];‍‍

Re: how can I make label using arcade that has multiple values

ScottShenberger — Wed, 21 Aug 2019 22:07:10 GMT

That looks like it did the trick! Thank you so much. Im learning Arcade on the fly so this was stumping me.

Re: how can I make label using arcade that has multiple values

BenBaker1 — Thu, 16 Apr 2020 19:20:42 GMT

I'm trying to create a similar expression, although I need the expression to then sum the values from inspection types that are coded into a survey123 form. The question is a select_multiple type, because they may complete more than one inspection type during a single survey, but then I'd like to be able to summarize the number of EACH inspection in a Dashboard (now that Arcade is supported in indicators).

I have a formula in Excel that will parse the field and sum the individual values, but I would like to keep things on the ESRI platform, if possible.

Excel formula to find all '100' (Annual) inspection types:

I'm not sure how to make the jump from Split to summing the values, or if another function (GroupBy?) might better achieve what I'm wanting.

Re: how can I make label using arcade that has multiple values

XanderBakker — Thu, 16 Apr 2020 20:21:26 GMT

Hi bbaker_mhgis ,

Although the new ArcGIS Dashboard (beta) has support for Arcade in the indicators, I am not sure if you can do a count of all values that contain a certain string.