Content Comparison

...

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

...

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])