Training Metrics: Chart Overdue Training By Department

Owned by Ann Ivey
Last updated: Apr 26, 2024
7 min read

This page contains examples of charting overdue training by department using Grand Avenue’s internal charting tool and Excel. Questions to help determine the appropriate training record search criteria are at

 

Training metrics using Grand Avenue’s internal charting tool

Click Generate Chart for Results to create a chart of training records.

Select “Generate Chart for Results”

Select the chart options shown below and click Generate Chart.

image-20240210-060856.png

Select the chart options shown below and click Generate Chart.

If the search results include only overdue records, the secondary chart method is not needed.

The charts above show the users with the top ten number of training records. Users outside of the top ten are combined into the “Other Values” group. The number of users displayed on the chart cannot be changed.

Select the chart options shown below and click Generate Chart.

If the search results include only overdue records, the secondary chart method is not needed.

The charts above show the departments with the top ten number of training records. Departments outside of the top ten are combined into the “Other Values” group. The number of departments displayed on the chart cannot be changed.

Select the chart options shown below and click Generate Chart.

If the search results include only overdue records, the secondary chart method is not needed.

Select the chart options shown below and click Generate Chart.

If the search results include only overdue records, the secondary chart method is not needed.

The charts above show the time to complete training in 30-day increments. Neither the number of increments nor their duration can be changed.

Training metrics using Excel

Charts generated in Excel from exported data take more time to create but have a full range of flexibility in how the data is presented.

Click the Export Results to Excel link on the search results page.

On the next page, click the Export Results to Excel button. Open the exported CSV file and save it as an Excel Workbook (*.xlsx). In the Excel workbook, click Insert → PivotTable. When prompted, place the PivotTable on a new worksheet.

Related Articles

 

Copyright © 2022, Grand Avenue Software, Inc. All rights reserved.