This custom report provides a list of users and their completion status for formal assessments attached to topics. This includes the topic details, such as the topic name and ID, and the assessment details, such as the assessment ID, the user's completion date, raw score, current assessment status (Started, Passed or Failed), and the assessment result, shown as a percentage (for example, 100%).
Example: You might generate this report to check that all users in your organisation have completed and passed assessments attached to topics that form part of mandatory training, such as vital security, data protection, or food hygiene training, which users must complete in order to work safely and securely in your organisation, and then follow up with any users who have not successfully passed those assessments to ensure that they do. You might also generate this report as proof that all users in your organisation have passed the required assessments attached to the topics and then share it with key members of your organisation.
Standard fields included in the report
The following standard fields are included in this report:
Notes:
The fields listed below are standard fields that cannot be removed from this report.
The list below does not include any custom profile fields that may be included in the report that are specific to your organisation or fields that can be added optionally during creation. For example, your organisation may have custom fields such as Location, Department, or Job Title that can be included in this report.
Column | Definition | Example |
|---|---|---|
User id | The unique identifier of the user who has access to the formal assessment. | 12345 |
Community id(s) | The unique identifier of the community where the topic containing the assessment exists. | 12345 |
Community name(s) | The name of the community that contains the topic that the assessment is attached to. | Sales Enablement Community |
Topic id | The unique identifier of the topic the assessment is attached to. | 12345 |
Topic name | The name of the topic the assessment is attached to. | Sales Enablement Programme |
Assessment id | The unique identifier of the Assessment id. | 12345 |
Assessment creation date | The creation date of the users' account | 08-07-2016 12:14:38 |
Last updated date | The date the formal assessment was last edited. If the formal assessment has never been edited; the creation date is displayed instead. | 08-07-2016 12:14:38 |
Assessment creation date | The date the formal assessment was created. | 08-07-2016 12:14:38 |
Start date | The date the user started the formal assessment. This is as soon as the user views the first question (clicks Start assessment). | 09-07-2016 12:14:38 |
Completed date | The date the user passed/completed the assessment | 09-07-2016 12:14:38 |
Assessment user status | The user’s status for the formal assessment.
| Passed |
Attempt id | The unique identifier for the user’s formal assessment attempt. | 12345 |
Raw score | The total number of points the user has scored in their latest attempt. This score is weighted by the platform and not manually by the formula set up in the formal assessment settings. | 10 |
Assessment result | The user’s assessment result, shown as a percentage. The result is shown as a percentage at all times, irrespective of the settings selected when the formal assessment was created. | 100% |