Content Comparison

...

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.

Image Removed Expand

Select the PivotTable Fields shown below.

1. Drag the Months (Training Completed Date) field to the Rows box.

2. Drag the Training Overdue? field to the Columns box.

3. Drag the Training Overdue? field to the Values box.

Image Removed

Here’s the PivotTable generated from the fields selected above.

Image Removed

Select the Pivot Table and click Insert → PivotChart. Here’s the corresponding PivotChart.

Image Removed

To display only the overdue training records, go back to the Pivot Table, click the arrow next to Column Labels, and deselect Overdue? = “No”.

Image Removed

Here’s the resulting PivotChart of overdue training by month.

Image Removed

...

Training metrics using PowerBI

Use the instructions in the previous section to export training record search results to Excel or use Connector Read to access training records directly from GAS. Import the training records to PowerBI.

Here are some example PowerBI charts:

...

1. Here are the settings for the first chart:

   1. Records: TrainingRecords

   2. X-axis:: TrainingCompletedDate

   3. (Column) y-axis: Count of TrainingOverdue

   4. (Column) Legend: TrainingOverdue

   5. Measures: None

   6. Filters:

      1. AssignedToUser=Yes

      2. TrainingCompleted=Yes

      3. TrainingOverdue=Yes or No

2. The second chart is the same data as the first chart but also includes a line showing the percent of training overdue each month. In additional to the settings shown above, the line requires the following settings:

   1. Line y-axis: Percent of Overdue Training

   2. Measures:

      1. Training Records = COUNT(TrainingRecords[TrainingOverdue])

      2. Code Block
         Count of TrainingOverdue for Yes = CALCULATE(     COUNTA('TrainingRecords'[TrainingOverdue]),     'TrainingRecords'[TrainingOverdue] IN { "Yes" }

      3. Code Block
         Percent of Overdue Training = DIVIDE([Count of TrainingOverdue for Yes],[Training Records])

...