fire department response performance

[JasonBonney]

Hello,

New to ESRI. I work for a fire district and am working on various analysis projects mostly related to fire accreditation. I have imported incidents including response performance to those incidents and our unique planning zones. I am trying to figure out how to calculate and thus display the overall 90th percentile of response performance in each planning zone. Any help would be greatly appreciated. 

[BrendanNewell]

hi @JasonBonney,

you can try this  Arcade Expression to calculate Percentile values for response times, have a look and see if this is suitable for your use case. This should assign a percentile value to all response times. You will then need to iterate through all planning zones to find the 90th percentile response times. You could do this manually or preferably through model builder.

// Get ALL features
var all = FeatureSetByName($datastore, "incidents", ["ResponseTime"], false)

// Count how many features have a lower ResponseTime than the current feature
var lower = Count(Filter(all, "ResponseTime < " + Text($feature.ResponseTime)))

// Count how many features have the same ResponseTime as the current feature
var equal = Count(Filter(all, "ResponseTime = " + Text($feature.ResponseTime)))

// Total number of features
var total = Count(all)

// Calculate percentile 
var percentile = ((lower + 0.5 * equal) / total) * 100

return percentile