Links

Custom Reports

Examples of custom reports that can be created from built-in reports.

Daily Aggregated Engagement Report

This report shows the number of unique users with billable minutes across all courses per day.
  1. 1.
    Download the Project Usage Digest Report for the appropriate month.
  2. 2.
    Open the .csv file in any spreadsheet software with pivoting capabilities, such as Microsoft Office Excel, LibreOffice Calc, or Google Sheets.
  3. 3.
    Create a pivot table by select Data > Pivot Table in the toolbar if using LibreOffice Calc or Google Sheets, or Insert > PivotTable if using Microsoft Office Excel.
  4. 4.
    Drag the following column names into the appropriate fields:
    • In the "Row" field, put Date
    • In the "Column" field, put Course Name
    • In the "Data" (or "Values" if using Microsoft Office Excel) field, put Users and aggregate by sum.
Creating the Daily Aggregated Engagement report using LibreOffice Calc.
This will result in a report that looks like the following:
Sum - Users
Course Name
Date
Course #1
Course #2
Course #3
Course #4
Total Result
2019-04-01
8
1
2
1
12
2019-04-02
5
3
7
3
18
2019-04-03
1
2
5
9
17
2019-04-04
4
12
1
0
17
Total Result
18
18
15
13
64