MC Dashboard: Drill Matrix - By Crew

Overview

The Drill Matrix - By Crew page helps you see which crew members have completed specific drills.

  • Assumptions:
    • Drills have been set up in forms.
    • Drills are scheduled monthly.
    • Each crew member is required to finish at least one occurrence of each drill each month.
  • Permanently set filters:
    • Items are forms only.
    • Items have “Generate Personnel Record = Yes”.
    • Date range is set to previous and current years.

Slicers

The slicers help you filter and sort the data on the page so you see only what you need.

Tips

  • Press Ctrl and click to select multiple items in a list.
  • If no items are selected from a particular list, data will be displayed for all the items in that list.

Drill Complete

  • Click No to filter for all drills that haven't been completed in the selected month.
  • Click Yes to filter for all drills with at least one completion in the selected month.

Crew

  • Only includes crew members in fleet/division with at least one completed drill.
  • When a division is selected, all assets in that division are selected.

Drill

  • Based on the Form Name field from the Forms data source in Helm CONNECT.
  • Displays the name of the completed drill.

Month

  • Based on the Filled Date field from Helm CONNECT.
  • Select a month in which drills were completed.

Year

  • Based on the Filled Date field from Helm CONNECT.
  • Select a year in which drills were completed.

Clear All

  • Click this button to clear all applied filters.

KPI Cards

The KPI cards summarize the performance on the page. They can be filtered by the slicers.

Crew

  • The number of crew members who have completed drills.

Distinct Drills Complete

  • Total number of distinct drills completed by crew members.

Tables

This page provides the following tables to illustrate your data.

NoteTo export data to a CSV file:

  1. Hover over the visualization and click the “” button that appears.
  2. From the drop-down menu, select Export data.

Asset

  • Asset on which the drill was completed.
  • Distinct number of drills that were completed on that asset.

Drill Matrix

Use the matrix to determine which crew members have completed which drills in each month of the previous and current years.

  • If a crew member has no instances of a certain drill completed in a specific month then that will be indicated by a 0.
  • For drills that are scheduled to be completed by any frequency other than monthly, some user knowledge is required:
    • Example 1: If a drill should be completed weekly, you must look for four completed instances of that drill each month to determine if the drill was completed weekly.
    • Example 2: If a drill should be completed quarterly and two months contain 0 values, you must look for a completed instance of that drill in the third month of the quarter to determine if the drill was completed within the quarter.