topic Re: Combining Multiple Categories in a Serial Chart in ArcGIS Dashboards Questions

Combining Multiple Categories in a Serial Chart

DaveBodak — Wed, 23 Feb 2022 15:26:56 GMT

We are working on a hydrant inspection program to be integrated with AGOL. The program has two crew members in the same vehicle where they will go to inspect and service hydrants, with 8 crew members in total (so 4 groups). As a part of the hydrant inspection form, there are two fields for the inspectors; "Inspector 1" and "Inspector 2", one for each of them to show that they were the ones who took place in the inspection.

As a part of this, I am designing a dashboard to display all types of information on the program. One of the elements is a serial chart showing the number of hydrants that an inspector has been responsible for:

The issue comes when attempting to combine this number for the two fields, this chart is only showing the inspections done by the "Inspector 1" field in this case. We are looking for a way to combine the "Inspector 1" and "Inspector 2" fields to count the number of times that an inspector is present in each field.

Re: Combining Multiple Categories in a Serial Chart

jcarlson — Wed, 23 Feb 2022 17:06:18 GMT

It sounds like you need a Data Expression.

There are lots of ways to do this, but the simplest is to go through each record and add each attribute to a new FeatureSet as its own row.

If you want the chart to interact with other widgets, like filtering by date / hydrant / etc., it gets more complex, but here's the simple version:

Re: Combining Multiple Categories in a Serial Chart

DaveBodak — Wed, 23 Feb 2022 19:07:06 GMT

This worked great, thank you very much!

Re: Combining Multiple Categories in a Serial Chart

D_AnneHammond — Wed, 03 Jul 2024 20:36:07 GMT

Hello @jcarlson , I am trying to do the same thing that @DaveBodak did a couple of years ago. My task is to put data from four different fields into one: Equipment1...Equipment4 --> Equipment so I can show proportional usage per feature using a pie chart in a Dashboard. The Arcade code is attached, adapted from @jcarlson 's code above - my real portal address is different but all else should work. If anyone can help me sort this out I'd be very grateful!! Many thanks.

Re: Combining Multiple Categories in a Serial Chart

KimberlyK — Tue, 17 Jun 2025 21:41:21 GMT

Hi Josh @jcarlson - Your solution was very helpful. I would like my chart to interact with other widgets, as you mentioned, but once I've created the serial chart using "inspector" from the FeatureSet as the grouped values category field, I can no longer relate back to any of my other widgets' actions target fields. It seems that the only way to use a filter is to manipulate the original data so that the source field and target field have the same name. This defeats the purpose of using a data expression and can also not be used with data not owned. Do you have a workaround to please share that you allude to in your solution? Thank you!