Custom Reports
Examples of custom reports that can be created from built-in reports.
This report shows the number of unique users with billable minutes across all courses per day.
- 1.
- 2.Open the
.csv
file in any spreadsheet software with pivoting capabilities, such as Microsoft Office Excel, LibreOffice Calc, or Google Sheets. - 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.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 |
Last modified 2yr ago