This custom report provides a list of users and their progress on 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.
Example: This report can be used to ensure that all users in your organisation have completed and passed assessments in topics that are part of mandatory training (for example, things like vital security, data protection, or food hygiene training), which users may be required to complete in order to work safely and securely at your organisation or within your industry. You might 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 required users in your organisation have passed the assessments and then share it with key members of your organisation, such as management, trainers, auditors, or heads of department so that they are made aware.
...
Standard fields included in the report
The following standard fields are included in this report:
| Info |
|---|
Notes:
|
Column | Definition | Example |
|---|
Attempt id
12345
Community id
User id | The unique identifier of the user who has access to the topic with 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: The user is an ordinary non-admin user.
Admin: The user is a site admin with access to the admin panel.
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
| Info |
|---|
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
| Info |
|---|
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
| Info |
|---|
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(s) | The unique identifier of the community where the topic |
exists. | 12345 |
Community name(s) | The name of the community |
where the topic |
exists. | Sales Enablement Community |
Topic id | The unique identifier of the topic with the formal assessment |
. | 12345 |
Topic name | The name of the topic with the formal assessment |
. | Sales Enablement Programme |
Assessment id | The unique identifier of |
the formal assessment in the topic. | 12345 | |
Assessment creation date | The date and time the formal assessment was created in the topic. | 08-07- |
2025 12:14:38 | ||||
Last updated date | The date and time the formal assessment in the topic was last edited.
| 08-07- |
2025 12:14:38 | |
Start date | The date the user started the formal assessment. This is as soon as the user clicks Start assessment and views the first question |
in the formal assessment. | 09-07- |
2025 12:14:38 | ||
Completed date | The date and time the user passed/completed the formal assessment. | 09-07- |
2025 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.
|
20 | ||||
Assessment result | The user’s assessment result, shown as a percentage. For example, if the user has answered all the questions correctly, 100% is shown in this column for that user.
| 100% |
Attempt count
For example, of this is the user’s first attempt, 1is shown, if it is their second attempt, 2 is shown, and so on.
Optional fields that can be included in the report
The fields in the Optional fields section are optional and are not included in the report by default. You might add some of these fields so that the report includes more detail. The fields listed below do not include any organisation-specific custom profile fields that may be present in the Optional fields section in your organisation’s version of the platform.
Column | Definition | Example | ||
|---|---|---|---|---|
Username | The username of the user with access to the topic with the formal assessment. | john.smith | ||
First name | The given name of the user with access to the topic with formal assessment. | John | ||
Last name | The family name/surname of the user with access to the topic with the formal assessment. | Smith | ||
The email address of the user with access to the topic with the formal assessment. | john.smith@fuseuniversal.com | |||
System role | The account type of the user with access to the topic with the formal assessment: The following user types are available:
| User | ||
Creation date | The date the user who has access to the topic was created in the platform. | 06-11-2015 14:28:47 | ||
Last activity date | The date and time the user who has access to the topic last accessed the platform. | 17-03-2023 16:39:11 | ||
Deactivation date | The date the user who has access to the topic was deactivated in the platform (only if applicable). | 17-03-2023 16:39:11 | ||
Time zone setting | The time zone of the user who has access to the topic, as set in their profile. | London | ||
Language setting | The language of the user who has access to the topic, as set in their profile. | en-GB | ||
Manager id(s) | The unique identifier of the user’s manager(s). | 97735
| ||
Manager username(s) | The username of the user’s manager(s). |
| ||
Manager e-mail(s) | The email address of the user’s manager(s). | jane.doe@fuseuniversal.com
| ||
Attempt count | The number of completion attempts the user has made for the formal assessment. For example: 1 is shown if a first attempt has been made, 2 is shown if a second attempt has been made, and so on.
| 2 | ||
Total questions | The total number of questions presented to the user |
in the formal assessment. |
20 | |
Nr of correctly answered questions | The total number of questions in the formal assessment that the user has answered correctly. |
| 12 | ||
Nr of incorrectly answered questions | The total number of questions the user has answered incorrectly in the formal assessment. |
1
Question type
The type of question defined by the assessment:
One correct
Many Correct
Scale
Ordering
Variation
Question id
The unique identifier for a specific question in the formal assessment.
| 10 |