This page contains several examples of training metrics charts that can be generated from Grand Avenue training record search results. It is divided into three sections:
Data Collection
Questions to help determine the appropriate training record search criteria are at How do I select the correct data to show my training metrics?
Click Search for Training Records.
If applicable, select search criteria
Training Item Type
Training Status
User Assigned to Complete [Yes/No]
Training Overdue? [Yes/No]
Training Completed? [Yes/No]
Training-related dates
Clear the Max # of Items to Display.
Click the Search button.
📘 Training metrics using Grand Avenue’s internal charting tool
Click Generate Chart for Results to create a chart of training records.
📘 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.