Custom Reports
Custom Reports allows you to create reports tailored to your requirements by selecting specific data fields, filters, and sorting options. You can generate reports for user and course activity or view consolidated progress across selected users and content types.
Access Custom Reports
Navigate to Reports from the dashboard and select Custom Reports.
Create a New Custom Report
- Click New Report.
- Select one of the following report types:
- Users and Courses Report – Displays user, course, enrollment, and progress details.
- Consolidated Report – Displays progress details for selected users and content types.
- Click Next.
- Enter the report Name and Description.
- Click Create and Edit to configure the report.
Users and Courses Report
The Users and Courses Report lets you select users, courses, enrollment details, and report fields to generate a customized report.
1. Configure Report Details
In the Details tab, review or update the following fields:
| Field | Description |
|---|---|
| Name | Specifies the report title. |
| Description | Summarizes the report's purpose and contents. |
| Data Source | Specifies the source of the report data, such as user activity or course progress. |
Click Continue to proceed to the Filters tab.
2. Configure Filters
Use the Filters tab to define which users, courses, and records appear in the report.
Users
Choose the required user selection option:
- All Users – Includes all users.
- Custom Selection – Allows you to select users based on specific criteria.
- Include Suspended Users – Enable the checkbox to include suspended users.
You can further refine the user selection using:
- Users
- Groups
- Job Levels
- Job Role
Courses
Choose one of the following options:
- All Courses – Includes all available courses.
- Custom Selection – Allows you to select specific courses from the dropdown list.
Enable Archived Courses if the report must include archived courses.
Date Range
Select the period for the report:
| Option | Description |
|---|---|
| Last 31 Days | Includes data from the previous 31 days. This is the default selection. |
| Last 3 Months | Includes data from the previous three months. |
| Last 6 Months | Includes data from the previous six months. |
| Last 1 Year | Includes data from the previous 12 months. |
| All | Includes all available data, regardless of the time period. |
Enrollment Status
Select the enrollment statuses to include:
- Not Started – Includes learners who have been assigned a course but have not started it.
- Completed – Includes learners who have completed the course.
After configuring the filters, click Continue.
3. Configure Report Data
In the Report Data section, select the fields to include and configure the sorting preferences.
Report Fields
Select the required fields from the available categories.
| Category | Examples |
|---|---|
| User Fields | Name, Email, City, Country, Job Role, Group |
| Course Fields | Course Name, Course Created Date, Course Duration, Course Languages |
| Enrollment Fields | User Course Assigned Date, User Course Completed Date |
| Statistics | User Course Status, Course Proficiency, Course Skill |
| User Custom Fields | Organization-specific fields such as Gender, Supervisor Code, and DOB |
Sorting Options
Use the available sorting options to control the order of report records.
- Sort By – Select a sorting option, such as Email (A–Z) or a custom field.
- Custom Field Sorting – Sort records using a selected custom field.
- Sort Column – Enable this checkbox to configure sorting based on selected report columns.
To configure column sorting:
- Enable Sort Column.
- Click Configure Sorting.
- In the Column Sorting window, select the required columns, such as Email or Course Name.
- Click Confirm to save the column sorting settings.
For email sorting, select the required order:
- A–Z (Ascending) – Sorts email addresses alphabetically.
- Z–A (Descending) – Sorts email addresses in reverse alphabetical order.
4. Preview and Export the Report
- Click Save and Preview to save your selections and generate a report preview.
- Review the report data.
- Click Export.
- In the Download Report window, select Download New Report.
- Enter a report file name. This field is mandatory.
- Click Download.
- When the report appears in the downloaded reports list, click the Export icon to download it.
The report is downloaded in XLSX format.
5. Schedule the Report
You can schedule the report to be generated automatically.
- Click Schedule Your Report.
- Enable the scheduling checkbox.
- Configure the scheduling settings:
| Setting | Description |
|---|---|
| Time Frame | Select Days, Weeks, or Months. |
| Email Address | Specify the recipient email address or addresses. |
| Every | Set the frequency of report generation. |
| Repeat | Specify how often the report repeats within the selected time frame. |
| From | Set the schedule start date. |
| To | Set the schedule end date. |
- Click Schedule to save and activate the schedule.
A success message confirms that the report has been saved.
6. Delete a Report
- Open the downloaded reports list.
- Click the Bin icon next to the report you want to delete.
- In the confirmation window, click Yes.
A success message confirms that the report has been deleted.
To learn how to access the schedule, Edit or Delete the custom report details, see Custom Report Schedule, Edit or Delete Options.
Consolidated Report
The Consolidated Report lets you view progress details for selected users across the chosen content types.
1. Configure Report Details
- Click New Report.
- Select Consolidated Report.
- Click Next.
- Enter the report Name and Description.
- Click Create and Edit.
In the Details tab, review or update the following fields:
| Field | Description |
|---|---|
| Name | Specifies the report title. |
| Description | Summarizes the report's purpose and contents. |
| Data Source | Specifies the source of progress data for the selected users and content. |
Click Continue to proceed to the Filters tab.
2. Configure Filters
Users
Choose the required user selection option:
- All Users – Includes all users.
- Custom Selection – Allows you to select specific users.
- Include Suspended Users – Enable the checkbox to include suspended users.
You can further refine the selection using Users and Groups.
Content Types
Choose one of the following options:
- All Content Types – Includes all available content types.
- Custom Selection – Allows you to select specific content types from the dropdown list.
Date Range
Choose the period for the report:
| Option | Description |
|---|---|
| Last 31 Days | Includes data from the previous 31 days. This is the default selection. |
| Last 3 Months | Includes data from the previous three months. |
| Last 6 Months | Includes data from the previous six months. |
| Last 1 Year | Includes data from the previous 12 months. |
| All | Includes all available data, regardless of the time period. |
Enrollment Status
Select the enrollment statuses to include:
- Not Started – Includes learners who have been assigned content but have not started it.
- Completed – Includes learners who have completed the content.
Click Continue after configuring the filters.
3. Configure Report Data
Select the report fields and sorting options required for the consolidated report.
Report Fields
The available categories include:
| Category | Examples |
|---|---|
| User Fields | Name, Email, City, Country, Job Role, Group |
| Course Fields | Course Name, Course Created Date, Course Duration, Course Languages |
| Enrollment Fields | User Course Assigned Date, User Course Completed Date |
| Statistics | User Course Status, Course Proficiency, Course Skill |
| User Custom Fields | Organization-specific fields such as Gender, Supervisor Code, and DOB |
Sorting Options
- Sort By – Select an option such as Email (A–Z) or a custom field.
- Custom Field Sorting – Sort records using a selected custom field.
- Sort Column – Enable this checkbox to configure sorting based on selected report columns.
To configure column sorting:
- Enable Sort Column.
- Click Configure Sorting.
- In the Column Sorting window, select the required columns, such as Email or Content Name.
- Click Confirm to save the sorting settings.
For email sorting, select A–Z (Ascending) or Z–A (Descending).
4. Preview and Export the Report
- Click Save and Preview to save your selections and generate a report preview.
- Review the report data.
- Click Export.
- In the Download Report window, select Download New Report.
- Enter a report file name.
- Click Download.
- In the downloaded reports list, click the Export icon to download the report.
The report is downloaded in XLSX format.
5. Schedule the Report
- Click Schedule Your Report.
- Enable the scheduling checkbox.
- Configure the schedule:
| Setting | Description |
|---|---|
| Time Frame | Select Days, Weeks, or Months. |
| Email Address | Specify the recipient email address or addresses. |
| Every | Set the frequency of report generation. |
| Repeat | Specify how often the report repeats within the selected time frame. |
| From | Set the schedule start date. |
| To | Set the schedule end date. |
- Click Schedule to activate the schedule.
A success message confirms that the report has been saved.
6. Delete a Report
- Open the downloaded reports list.
- Click the Bin icon next to the report you want to delete.
- In the confirmation window, click Yes.
A success message confirms that the report has been deleted.
Custom Reports List
The Custom Reports list displays the reports you have created.
| Column | Description |
|---|---|
| Name | Displays the report title. |
| Description | Provides a summary of the report. |
| Type | Indicates whether the report is a Users and Courses Report or a Consolidated Report. |
| Created By | Displays the name of the report creator. |
| Created On | Displays the date and time the report was created. |
| Actions | Provides options to schedule, edit, or delete the report. |
To learn how to access filters in custom reports, see Custom Report Filter Options.
