Arcade Data Expression - Return Predominant Value while Grouping By Another Field
I hope I understand what you mean by "Predominant Incident".
I defined it to mean if you had 10 car crashes (for example 5 Multi Car, 3 Single Car, 1 Bicycle, 1 Pedestrian) the predominant type would be "Multi Car"
Another thing I will say is that I'm testing this on my home ArcGIS Pro single use install, so I didn't write the Arcade for a dashboard pulling from a portal, but the logic should be pretty similar.
I had test data laying around so I used that and wrote an attribute rule to populate a new field named "Predominent" (spelled wrong) with the predominant value from the TextTst field (in the image below I updated the IntTest field from 6 to 7 to fire the Arcade to populate the Predominent field)
The expression I used uses OrderBy (DESCending) to order the feature set returned by the GroupBy function in descending order from most to least occurrences of COUNT. The First function just takes the first record from this ordered feature set.
The only problem is if you have a tie its only going to take the first one.
Here it is in plain text:
return First(OrderBy(GroupBy((FeatureSetByName($datastore, 'TestPoints',['TxtTest'],false)), 'TxtTest',{name: 'NumberTest', expression: '1', statistic: 'COUNT'}),'NumberTest DESC')).TxtTest
Hope this helps.
K
Maybe no one is reading this one anymore, but I revisited it.
I couldn't stop thinking about this one so I gave it a go in a Dashboard and it turned out to be much harder than I thought it would be. I couldn't figure out how to do it just using GroupBy and OrderBy when in the Dashboard environment (long story but I couldn't get my Total Incidents, Predominant Incident Type, and Incident Name all in the same FeatureSet using this method... not saying its not possible. I just couldn't figure it out).
Then I found this great sample on github:
Wow... Very cool! It shows you how to return your own custom FeatureSet from a dictionary.
Using these two fields in my sample data:
And this code to define the data source to use for my list:
// Write an expression that returns a FeatureSet.
// Documentation: https://arcg.is/3c419TD
// Samples: https://arcg.is/38SEWWz
//----------------------------------------------------------
//Portal feature set
//----------------------------------------------------------
var IncidentsByCounty = GroupBy(FeatureSetByPortalItem(Portal('https://garbadehome.maps.arcgis.com'),'baa95b02c52147bf8962379e85831fe8',0,['County','Incident'], True),
[ //fields/expressions to group statistics by
{name: 'County', expression: 'County'},
{name: 'Incident', expression: 'Incident'}
],
[ // statistics to return for each unique categroy
{name: 'CountOfInc', expression: 'Incident', statistic: 'COUNT'}
]
)
var cntyNoIncident = GroupBy(IncidentsByCounty,
[ //fields/expressions to group statistics by
{name: 'County', expression: 'County'}
],
[ // statistics to return for each unique categroy
{name: 'Predom', expression: 'CountOfInc', statistic: 'MAX'},
{name: 'TotalInc', expression: 'CountOfInc', statistic: 'SUM'}
]
)
// Create empty array for features, feat object to populate array
var features = [];
var feat;
for(var cnty in cntyNoIncident){
var countyname = cnty.County
var predomCount = cnty.Predom
var incidentTotal = cnty.TotalInc
var predomIncType = filter(IncidentsByCounty,"County = @countyname AND CountOfInc = @predomCount")
var x = []
for (var topIncident in predomIncType){
Push (x, topIncident.Incident)
}
feat = {
attributes: {
County: countyname,
PredomIncidentType: Concatenate(x,'/'),
PredomIncidentTotal: predomCount,
TotalIncidents: incidentTotal,
},
}
Push(features, feat);
}
var outputDict = {
fields: [
{name: 'County', type: 'esriFieldTypeString'},
{name: 'PredomIncidentType', type: 'esriFieldTypeString'},
{name: 'PredomIncidentTotal', type: 'esriFieldTypeInteger'},
{name: 'TotalIncidents', type: 'esriFieldTypeInteger'},
],
geometryType: '',
features: features,
}
return FeatureSet(Text(outputDict));
//return predomIncType
I generated this List:
I learned a bunch so thank you for the question.
K
