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.