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 How do I select the correct data to show my training metrics?
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Collect Training Data
| excerpt-include | ||
|---|---|---|
|
...
|
...
|
...
|
Training metrics using Grand Avenue’s internal charting tool
Click Generate Chart for Results to create a chart of training records.
...
...
Select the chart options shown below and click Generate Chart.
...
| title | Example 2: Chart Overdue Training by User |
|---|
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 chart show the departments with the top ten number of training records.
...
| title | Example 3: Chart Overdue Training by Department |
|---|
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.
...
If there are more than 10 departments, the rest are combined into an “Other Values” group. The number of departments displayed on the chart cannot be changed.
...
...
Training
...
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.
...
| Expand | ||
|---|---|---|
| ||
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.
...
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.
...
| Expand | ||
|---|---|---|
| ||
Select the PivotTable Fields shown below.
 Here’s the PivotTable generated from the fields selected above.  Select the Pivot Table and click Insert → PivotChart. Here’s the corresponding PivotChart.  |
| Expand | ||
|---|---|---|
| ||
Select the PivotTable fields shown below.
 Here’s the PivotTable generated from the fields selected above.  Select the Pivot Table and click Insert → PivotChart. Here’s the corresponding PivotChart.  To display only the overdue training records, go back to the PivotTable, click the arrow next to Column Labels, and deselect Overdue? = “No”.  Here’s the resulting PivotChart of overdue training by employee.  |
...
...
| title | Example 3: Chart Overdue Training by Department |
|---|
Select the PivotTable fields shown below.
Drag the Department Name field to the Rows box.
Drag the Training Overdue? field to the Columns box.
Drag the Training Overdue? field to the Values box.
...
Here’s the PivotTable generated from the fields selected above.
...
Select the Pivot Table and click Insert → PivotChart. Here’s the corresponding PivotChart.
...
To display only the overdue training records, go back to the Pivot Table, click the arrow next to Column Labels, and deselect Overdue? = “No”.
...
Here’s the resulting PivotChart of overdue training by department.
...
| Expand | ||
|---|---|---|
| ||
Select the PivotTable Fields shown below.
 Here’s the PivotTable generated from the fields selected above.  Select the Pivot Table and click Insert → PivotChart. Here’s the corresponding PivotChart.  To display only the overdue training records, go back to the Pivot Table, click the arrow next to Column Labels, and deselect Overdue? = “No”.  Here’s the resulting PivotChart of overdue training by month.
|
...
| title | Example 5: Chart the number of days to complete training |
|---|
Delete or hide all columns in the exported data except Training Overdue?, Training Completed Date, and Training Record Created Date. Add a new column “Days to Complete Training” to the worksheet. In this example, the days to complete training is computed by subtracting the Training Record Created Date from the Training Completed Date. Fill the formula down the entire “Days to Complete Training” column.
...
Select the PivotTable Fields shown below.
Drag the Days to Complete Training field to the Rows box.
Drag the Training Overdue? field to the Columns box.
Drag the Training Overdue? field to the Values box.
...
Here’s an example PivotTable generated from the fields selected above.
...
Right click on the first column and select Group…
...
Select the number of days to include in each grouping (example: 3 days per group)
...
Here is the same Pivot Table with the number of days to complete training in groups of 3 days.
...
Select the Pivot Table and click Insert → PivotChart. Here’s the corresponding PivotChart.
...
| Filter by label (Content by label) | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|