MC Dashboard: Asset Certifications
Overview
The Asset Certifications page provides a detailed view of all expired and valid asset certifications.
- Permanently set filter: Asset Name field is not blank.
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.
Division, Asset
- Includes only divisions and assets with at least one completed asset certification. If a division or asset doesn't have any completed asset certifications, it won't appear in the list.
- When a division is selected, all assets in that division are selected.
Certification Category
- Based on the Certification Category field from Helm CONNECT, for example, Coast Guard, License, etc.
Certification Type
- Based on the Certification Type field from Helm CONNECT. This is the actual name of the certification.
Required to Operate
- Based on the Required to Operate field from Helm CONNECT.
- Options are Yes or No.
Status
- Based on the Expiry Date field from Helm CONNECT.
- Logic: If it's before the expiry date, the certification is considered to be valid, if it's on or after the expiry date, the certification is considered to be expired.
Clear All
- Click this button to clear all applied filters.
Visualizations
Bar Graph
- Certifications can have one of the following four statuses:
- Expiring < 30 Days (Red): Certifications that will expire in less than 30 days or have already expired.
- Expiring in 30-60 Days (Orange): Certifications that will expire in 30 or more days but fewer than 60 days.
- Expiring in 60-90 Days (Yellow): Certifications that will expire in 60 or more days but fewer than 90 days.
- Expiring in > 90 days (Green): Certifications that will expire in 90 or more days.
- Tooltip: Hover over an individual status on the data bar to display the status name as well as the total number of certifications that have that status.
- Click an individual color on the data bar to filter the entire dashboard to show data for just that status.
- The total number of certifications, including all four statuses, is displayed to the far right of the data bar.
Table
This page provides a table to illustrate your data.
NoteTo export data to a CSV file:
- Hover over the visualization and click the “…” button that appears.
- From the drop-down menu, select Export data.
Asset Certifications Table
- Columns include:
- Assets
- A column for each certification type.
- Conditional Formatting:
- Red X: Represents an expired certification.
- Green Check Mark: Represents a valid certification.
- Blank: Represents a crew member who doesn't have that specific certification.
- Tooltip: Hover over an individual cell in the table to display the following information:
- Expiry Date: Expiry date of certificate; if a certification has no expiry date, this will be blank.
- Days Remaining: Days remaining until the certificate expires. If the certificate has expired this will be a negative number; if the certificate has no expiry date this will be 10,000.
- Required to Operate: Yes or No.