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.
- 2.Open the
.csvfile 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
- In the "Column" field, put
- In the "Data" (or "Values" if using Microsoft Office Excel) field, put
Usersand aggregate by sum.
Creating the Daily Aggregated Engagement report using LibreOffice Calc.
This will result in a report that looks like the following: