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.
Download the Project Usage Digest Report for the appropriate month.
Open the .csv file in any spreadsheet software with pivoting capabilities, such as Microsoft Office Excel, LibreOffice Calc, or Google Sheets.
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.
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
​

Built-In Reports

Next - API

Zapier

Last updated -5

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