ArcGIS Dashboard Serial Chart - Data Question

173
4
Jump to solution
2 weeks ago
GISPro1
New Contributor II

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.

0 Kudos
1 Solution

Accepted Solutions
GISPro1
New Contributor II

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!

View solution in original post

4 Replies
DavidPike
MVP Frequent Contributor

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

0 Kudos
GISPro1
New Contributor II

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?

0 Kudos
DavidPike
MVP Frequent Contributor

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.

GISPro1
New Contributor II

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!

View solution in original post