Part 1: Accreditation Data Collection

Pulling data for accreditation purposes can be extremely difficult, confusing, time consuming, and expensive. Not any more!

One of our customers recently came to us with the goal of filling out this table specified by the CFAI Accreditation Model. It probably seems daunting at first, but lets display this data in our Dashboard — all in less than 20 minutes.

So if we look at this table— we can isolate a few metrics that we need to collect:

• Alarm Handling
• Turnout Time
• Travel Time
• Total Response Time
• Effective Response Force Time
• Effective Response Force Travel Time

Getting Started

1. Click the Visualize tab
2. Click the + button to create a new visualization
3. Select the Data Table option
4. Select the index pattern that contains *fire-incident*. You DO NOT want to select the index pattern that has the word apparatus in it.

Creating a New Data Table

Adding Metrics

Now that we have a basic table lets report on our desired metrics.

Let’s add 90 percentile Alarm Handling

1. Update the time range to a larger period of time (Last 5 years)
2. Click Add Metrics. Click the Metric Button
3. Select Percentiles as the Aggregation Type
4. Start typing “alarm handling” as the Field — select ‘durations.alarm_handling seconds’
5. Remove all other percentiles and modify one to 90, which represents the 90th percentile
6. Add a custom label as “Alarm Handling”
7. Press play button
8. Save the visualization

Adding Metrics

Now lets repeat for the other metrics in question

• Turnout Time is represented as ‘durations.turnout.seconds’
• Travel Time is represented as ‘durations.travel.minutes’
• Total Response Time is represented as ‘durations.total_response.minutes’
• Effective Response Time is represented as ‘durations.effective_response_force_response.minutes’
• Effective Response Travel Time is represented as ‘durations.effective_travel_force.minutes’

We should now have a table such as this

Basic Metrics

Aggregating By Date

Great, so we are now rolling up our desired metrics — but we now need to aggregate on several facets. Lets tackle the event date first by bucketing the data into Date ranges.

1. Click Split Rows
2. Select Date Histogram as Aggregation
3. Select Yearly as Interval
4. Add a custom label as “Year”
5. Press play button
6. Save the visualization

Aggregating by Year

Aggregating By Population Density

Wow, getting somewhere! Lets now aggregate by Population Density.

1. Click Add sub-buckets
2. Click Split-Rows
3. Select Terms as Sub Aggregation
4. Start typing “population” as the Field — select ‘address.population_density’
5. Add a custom label as “Population Density”
6. Press play button
7. Save the visualization

Aggregating by Population Density

Aggregating By Category/Response Class

Looking good — but this table represents all incidents. We really need to aggregate across incident types or response class (e.g. Fire, EMS, etc).

1. Click Add sub-buckets
2. Click Split-Table
3. Select Terms as Sub Aggregation
4. Start typing “response_class” as the Field — select ‘description.response_class’
5. Add a custom label as “Response Class”
6. Press play button
7. Save the visualization

Aggregating By Category

Aggregating By Risk

Finally, we will want to break the table by risk.

1. Click Add sub-buckets
2. Click Split-Table
3. Select Terms as Sub Aggregation
4. Start typing “risk_category” as the Field — select ‘description.risk_category’
5. Add a custom label as “Risk”
6. Press play button
7. Save the visualization

Wrapping Up

Just like that — you have a starting point for your accreditation reporting. Stay tuned to Part 2 to see how we can filter out outliers, export to CSV, and more.

Need help with accreditation reporting?

— email us at contact@statengine.io