Columns and filters available on custom reports

Creation date of the user account, in the format YYYY/MM/DD HH:mm.

If the user was deleted, then added again, this is the original date of the first creation.

Value of the External ID of the user if there is one.
The report includes one column per platform.

If no value is given by the Identity Provider (IdP), this cell is empty.

Limits the exported data to only users belonging to the selected groups.

• If no group is selected, the report will contain data for all groups that the exporter can view the data of.
• If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
• If you select 100 or more groups, the export will include only the main CSV file.

• Tags
• Session dates

• Tags
• Session dates

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.

• User status
• User Custom Field
• User Registration Date
• Last activity date
• Groups

After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

Difference in hours between the time the user connected to and disconnected from the course, in the format DD: HH: mm.

If available, this is calculated using the reported attendance duration from Zoom/Microsoft Teams.

If Zoom/Teams data is not available, this is a cumulative sum of time spent on all steps.

Value of the External ID of the user if there is one.

The report includes one column per platform.

Indicates with an "x" that the user belongs to the group.

The report only includes a group column for groups that the exporter has coach or admin permissions for.

Percentage of course completion after the learner logs out of the path session.

Displays "-" when a learner connects to a session but doesn't complete any activity.

Limits the exported data to only users belonging to the selected groups.

• If no group is selected, the report will contain data for all groups that the exporter can view the data of.
• If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
• If you select 100 or more groups, the export will include only the main CSV file.

• Tags
• Session dates

• Tags
• Session dates

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.

• User status
• User Custom Field
• User Registration Date
• Last activity date
• Groups

After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

• Pending session opening: The learner is enrolled in a path session which hasn't started yet.
• Not yet started: The learner is enrolled in an ongoing path session but they haven't started the path yet.
• On time: The path session is ongoing, and the learner fulfills all the following conditions:
  • They started the path.
  • They completed all the mandatory steps with a past due date.
  • They haven't completed all the mandatory steps either without a due date, or with a due date that has not passed yet.
• Awaiting correction: The learner has started the path and is waiting for the validation of an assessment before continuing the path.
• Late: The path session is ongoing, and the learner fulfills all the following conditions:
  • They started the path.
  • They haven't completed at least one mandatory step with a past due date.
• To retake: The path session is ongoing, and the learner fulfills at least one of the following conditions:
  • They haven't reached the minimum score for at least one mandatory course, and they haven't reached the maximum number of authorized attempts for mandatory courses.
  • They haven't completed the path within the time limits, and they haven't reached the maximum number of attempts for mandatory courses.
  • They completed at least one step outside of the path context with mandatory replay.
• Unsuccessful: Either the path session ended when the status was Not yet started, Late, On time, To retake, or the learner fulfills at least one of the following conditions:
  • They haven't reached the minimum score for at least one mandatory step, and they reached the maximum number of attempts for the mandatory steps.
  • They haven't completed the path within the time limits, and they reached the maximum number of attempts for the mandatory steps.
• Successful: The learner fulfills all the following conditions:
  • They completed all the mandatory steps in the path.
    • If the path has the mandatory replay option activated, the learner must have completed all the mandatory steps within the path session, even if they already completed the courses elsewhere.
  • They reached the minimum score in all the mandatory courses that have one.
  • They completed the path within the time limits.

Time spent by the learner on steps within the path, in the format DD:HH:mm.

If available, this is calculated using the reported attendance duration from Zoom/Microsoft Teams.

If Zoom/Teams data is not available, this is a cumulative sum of time spent on all steps within the path.

• yes: the learner earned the certificate.
• no: the learner didn’t earn the certificate.
• -: the path doesn’t contain a certificate.

Columns for each step included in the path:

• Step # type
• Step # title
• Step # status
• Step # progress
• Step # score
• Step # time spent
• Step # waiving cause
• Step # waiving source
• Step # waiving source type

Indicates if a user is actively enrolled in a path session or not.

If a user was enrolled in a path session in the past, but they were unenrolled from the path session, that user will display in the path sessions report. In this example, the user is not actively enrolled in the path session, so this column would show as Unenrolled.

Value of the field Estimatedduration in the path settings (under the Build your training section) converted to absolute time, in the format HH:MM:SS. For example:

• 1 day in the path settings is converted to 24:00:00 on the path report. To convert the estimated duration in the report to days, divide it by 24.
• 1 week in the path settings is converted to 168:00:00 on the path report. To convert the estimated duration in the path report to weeks, divide by 168.
• 1 month in the path settings is converted to 720:00:00 on the path report. To convert it to months, divide by 720.

Date and time when the learner clicked START in the path page, in the format YYYY/MM/DD HH:mm. If the learner played the path several times, only the last attempt is kept.

This column remains empty:

• If the learner hasn't clicked on at least one path step on the platform.
• If the learner has started a path step before the path session start date for a path where mandatory replay is not activated. For example, for a path without mandatory replay:
  • When a learner starts a course step before the path session started, the time spent is specified, but the learner has no start date in the report.
  • When a learner completes all the steps before the path session started, the path is marked as successful, the time spent and completion date are specified in the report, but the learner's start date remains empty.

• true: the path is linear.
• false: the path is non-linear.

• On time: the step has not been completed, and is either optional, has no due date, or has a due date that isn’t passed yet.
• Late: the step has a due date that is passed, and has not been completed.
• Completed: the step has been completed.

This column is added to the report when Details per step is selected.

Time spent by the learner on the step, in the HH:mm format.

This is calculated using the reported attendance duration from Zoom/Microsoft Teams.

If the Zoom/Teams attendance is unavailable, the calculation will be as follows:

• Course: Actual duration.
• Classroom: Difference between the end date and start date for the classroom slot (for virtual classrooms it will be the time the learner spent in the call).
• Path: Sum of all steps duration
• Assessment: 0 by default (no time is computed for assessments).

This column is added to the report when Details per step is selected.

Type of the step:

• Course
• Classroom
• Path
• Assessment

This column is added to the report when Detailsperstep is selected.

If the course was waived, display course.

You can filter by:

• Enrollment date: Limits the exported data to learners who were enrolled during the selected time frame.
• Completion date: Limits the exported data to learners who completed paths during the selected time frame.
• Learner start date: Limits the exported data to learners who took their first action on the platform in the context of a given path during the selected time frame.

When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from a selected time frame relative to the current date, such as the last seven days.

Limits the exported data to only users belonging to the selected groups.

• If no group is selected, the report will contain data for all groups that the exporter can view the data of.
• If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
• If you select 100 or more groups, the export will include only the main CSV file.

The export will include data only for the content that is part of the selected path sessions.

If a session does not require mandatory replay, it will also include statistics for content played outside of the selected path sessions. This could involve courses accessed directly from the catalog or those completed within the context of other path sessions with the same courses as the selected ones.

• Tags
• Session dates

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.

• User status
• User Custom Fields
• User Registration Date
• Last activity date
• Groups

After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

Result of the course, with the following possible values:

• Success when the learner has completed the course and they have reached the minimum score in courses that have one.
• To retry when the learner has completed a course with a minimum score but has not reached the minimum score.
• Failed when the learner has completed a course, has not reached the minimum score and either the session is closed or the learner has reached the maximum number of attempts.
• Awaiting correction when the learner has completed a course with a minimum score and with questions that require a correction.

The column remains empty when the result is undefined due to:

• The learner not completing the course.
• The course being migrated.

• Tags

Limits the exported data to only users belonging to the selected groups.

• If no group is selected, the report will contain data for all groups that the exporter can view the data of.
• If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
• If you select 100 or more groups, the export will include only the main CSV file.

• Tags
• Session dates

• Tags
• Session dates

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.

• User status
• User Custom Field
• User Registration Date
• Last activity date
• Groups

After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

• registered: the learner is registered to a classroom slot for which attendance was not filled.
• attended: the learner was added to the attendance list.
• missed: the learner was not added to the attendance list (and at least one other learner was added to the list).

• on-site: the classroom slot is on-site.
• virtual: the classroom slot is virtual.

• Classroom type
• Path sessions

Limits the exported data to only users belonging to the selected groups.

• If no group is selected, the report will contain data for all groups that the exporter can view the data of.
• If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
• If you select 100 or more groups, the export will include only the main CSV file.

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.

• User status
• User Custom Fields
• User Registration Date
• Last activity date
• Groups

After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

• 0 if the Learner answered incorrectly.
• 1 if the Learner answered correctly
• Blank if the question is an Opinion question, or an Open-ended question that has not been corrected yet.

Limits the exported data to only users belonging to the selected groups.

• If no group is selected, the report will contain data for all groups that the exporter can view the data of.
• If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
• If you select 100 or more groups, the export will include only the main CSV file.

• Tags
• Question type
• Courses

• Tags
• Session dates

• Tags
• Session dates

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.

• User status
• User Custom Field
• User Registration Date
• Last activity date
• Groups

After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.