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.
Solved! Go to Solution.
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!
Can you explain more what parcels by attempt number is supposed to be? I can't work it out.
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?
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.
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!