Skip to main content
All CollectionsSupport GuideDashpivot - WebFormulas Functions
Use Case Examples - Safety: how to create a summary of incidents and incident rate
Use Case Examples - Safety: how to create a summary of incidents and incident rate

Learn how to summarise the number of incidents in the register and calculate for the incident rate

Janmari Tanga-An avatar
Written by Janmari Tanga-An
Updated over 6 months ago

Summarising the number of incidents means that you're tallying the number of times an incident has occured as logged in the incident register, and the incident rate is the number of incident days divided by the total number of days.

There are various types of incidents, the following are some examples:

  1. Safety Incidents

    1. Accidents/Injuries

    2. Near Misses

    3. Falls from Height

    4. Slips, Trips, and Falls

  2. Security Incidents

    1. Theft

    2. Vandalism

    3. Violence

    4. Unauthorised Access

  3. Operational Incidents

    1. Equipment Failure

    2. Structural Failure

    3. Utility Disruption

    4. Production Downtime

To start, navigate your cursor to the left tab and choose 'Default' table under 'Table'. A default table is usually used for registers as the number of rows/total logs aren't fixed. Your incident register should closely look like this:

Table 1 Incident Register (Default table)

#

Date Reported

Incident Type

Description

Status

Complete by

Person Responsible

(Date field) - B1

(Dropdown list) - C1

(Text field) - D1

(Formula field) - E1

(Text field) - F1

(Text field) - G1

For example, your Incident Type (dropdown list) list contains the following:

  • Accidents/Injuries

  • Near Misses

  • Falls from Height

Use another table (Prefilled table) for your summary and it may closely look like this:

Table 2 Summary/Incident Rate (Prefilled table)

Counts

Incident Rate

Accidents/Injuries

(Formula field) - B1

(Formula field) - C1

Near Misses

(Formula field) - B2

(Formula field) - C2

Falls from Height

(Formula field) - B3

(Formula field) - C3

In order to calculate the summary of incidents,

For Accidents/Injuries at Table 2 cell B1:

=COUNTIF(Table1!C:C, "Accidents/Injuries")

For Near Misses at Table 2 cell B2:

=COUNTIF(Table1!C:C, "Near Misses")

For Falls from Height at Table 2 cell B3:

=COUNTIF(Table1!C:C, "Falls from Height")

In order to calculate the incident rates,

For Accidents/Injuries at Table 2 C1:

=B1/COUNTA(Table1!A:A)*100

For Near Misses at Table 2 cell C2:

=B2/COUNTA(Table1!A:A)*100

For Falls from Height at Table 2 C3:

=B3/COUNTA(Table1!A:A)*100

Did this answer your question?