This custom report provides a list of users and their progress on 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, and assessment result.
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 |
|---|---|---|
Attempt id | The unique identifier for the user’s formal assessment attempt. | 12345 |
User id | The unique identifier of the user who has access to the formal assessment. | 12345 |
Username | The username of the user who has access to the formal assessment. | john.doe |
First name | The first name of the user who has access to the formal assessment. | John |
Last name | The last name of the user who has access to the formal assessment. | Doe |
The email address of the user who has access to the formal assessment. | john.doe@fuseuniversal.com | |
System role | The user's account type. The following user types are available:
| User |
Creation date | The creation date of the users' account | 08-07-2016 12:14:38 |
Last activity date | The last date the user accessed the platform. | 08-07-2016 12:14:38 |
Deactivation date | The date the user’s account was deactivated (if applicable) | 08-07-2016 12:14:38 |
Time zone setting | The user’s time zone as set in their profile. | GMT +1:00 London |
Language setting | The user's language; as set in their profile. | en - English |
Manager id | The unique identifier of the user’s manager. | 33344 If the user has multiple managers, the IDs are separated by a semi colon. For example: 33344;28719 |
Manager username | Username of manager | jane.doe If the user has multiple managers, the usernames are separated by a semi colon. For example: jane.doe; jon.doe |
Manager e-mail | The e-mail address of the user’s manager. | jane.doe@fuseuniversal.com If the user has multiple managers, the emails are separated by a semi colon. For example: jane.doe@fuseuniversal.com;jon.doe@fuseuniversal.com |
Community id | The unique identifier of the community where the topic containing the assessment exists. | 12345 |
Community name | 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 date the formal assessment was created. | 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 |
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 |
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% |
Attempt count | The attempt number. | 2 |
Total questions | The total number of questions the user was required to answer. | 5 |
Nr of correctly answered questions | The total number of questions in the assessment that the user answered correctly. | 4 |
Nr of incorrectly answered questions | The total number of questions the user answered incorrectly. | 1 |
Question type | The type of question defined by the assessment:
| |
Question id | The unique identifier for a specific question in the formal assessment. | 12335 |