topic Re: ArcGIS Dashboard Serial Chart - Data Question in ArcGIS Online Questions

ArcGIS Dashboard Serial Chart - Data Question

GISPro1 — Tue, 08 Jun 2021 21:04:57 GMT

I am creating a chart in ArcGIS Dashboard from a table. Each record in the table contains ParcelID and OutreachType. Each parcel has multiple entries. I need to create a serial chart that shows the number of parcels by the number of outreach attempts. For example:

ParcelID OutreachType
12345 Email
12345 Phone
12345 Visit
54321 Visit
54321 Email

So the output that I need in the serial chart would be:

Parcels by Attempt Number
1 = 0
2 = 1
3 = 1

Seems very straightforward, right? It's got this non-developer stumped. Thank you for your help.

Re: ArcGIS Dashboard Serial Chart - Data Question

DavidPike — Tue, 08 Jun 2021 21:20:52 GMT

Can you explain more what parcels by attempt number is supposed to be? I can't work it out.

Re: ArcGIS Dashboard Serial Chart - Data Question

GISPro1 — Tue, 08 Jun 2021 21:26:26 GMT

Sorry about that. From the example... ParcelID 12345 has 3 outreach attempts (email, phone, and visit), Parcel 54321 has 2 outreach attempts (visit and email). So with this limited dataset, there is 1 parcel with 2 attempts and 1 with 3 attempts. As this table grows, I want to report on the number of parcels that have 1 attempt, 2 attempts, 3 attempts, 4 attempts, etc. Does that make better sense?

Re: ArcGIS Dashboard Serial Chart - Data Question

DavidPike — Tue, 08 Jun 2021 21:54:25 GMT

Thanks for clarifying, I don't actually think it's straightforward as I'm leaning towards a data expression being required to do the heavy lifting. Or maybe/hopefully I'm missing something simple.

Re: ArcGIS Dashboard Serial Chart - Data Question

GISPro1 — Thu, 10 Jun 2021 15:25:04 GMT

Actually, I figured it out with a little Arcade.

First I set up the following expression to return a FeatureSet:

return GroupBy(fs,['ParcelNum'],
[{name: 'total_attempts',expression: 'OutreachAt', statistic: 'COUNT'}]);

Then set the Category field to 'total_attempts' with a simple count by 'Row_ID'

Worked like a charm!