Sort report columns in Report Builder
Overview
Sorting determines the order of rows in the downloaded report file. Apply sorting whenever consistent output matters.
Add a sort
In this example, you’ll find out the courses that have the highest completions.
-
Launch Report Builder and select Create Report.
-
Type the name and description of the report.
-
Select the following columns: :
- Learning Object - Learning Object Name
- Learning Object - Learning Object Status
- Learning Object - Completion Count
-
In the Sorting section, select Add sorting.
-
Select Learning Object - Completion Count.
-
Select a sort order- Ascending or Descending
-
Select Add.
-
Select Save Report and select Actions > Download to download the report.
The downloaded report lists all records, sorted by the number of course completions.
Add multi-column sorting
In this example, you’ll generate a report to measure performance across managers.
To sort by more than one column:
-
Launch Report Builder and select Create Report.
-
Type the name and description of the report.
-
Select the following columns: :
- User - Name
- User - Manager Name
- Module Transcript - Status
- Module Transcript - Progress Percent
-
Add the following aggregates:
- Group by User-Manager Name
- Count Distinct User-Name
- Count If=COMPLETED Module Transcript - Status
- Average Module Transcript - Progress Percent
-
In the Sort section, add the following multi-column sorting:
- Module Transcript - Status: Descending
- User - Manager Name: Ascending
-
Select Save Report and select Actions > Download to download the report.
The downloaded report provides a manager-wise performance summary, showing distinct learner counts, status-based enrollment counts, and average progress percentages. It highlights participation levels and training progress across different manager groups.