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 |
---|---|---|
User id | The unique identifier of the user who has access to the |
1
Username
The username of the user.
johndoe
First name
The first name of the user.
John
Last name
The last name of the user.
Doe
The email address of the user.
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
1-1-2021
Last activity date
The last date the user accessed Fuse.
17-5-2021
Deactivation date
The date the user’s account was deactivated.
19-5-2021
Time zone setting
The users' 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.
2
Manager first name
The first name of the user’s manager.
Jane
Manager last name
The last name of the user’s manager.
Doe
Manager e-mail
The e-mail address of the user’s manager.
Profile fields (eg Department)
The header contains the label of the custom profile field, the field itself contains the value as presented on the UI of the custom profile field.
(values of the field are either in the table profile_field_values, or profile_field_options)
Sales
Community id
The unique identifier of the community where the topic exists.
1
Community name
The name of the community where the topic exists.
Sales Enablement Community
Date created
The date the topic was created.
1-1-2021
Last updated date
The date the topic was last edited.
If the topic has never been edited, the creation date is displayed instead.
1-1-2021
Topic id
The unique identifier of the topic.
2
Topic Name
The title of the topic.
Sales Enablement Programme
User’s topic status
The user’s progress status for the topic.
The available statuses are:
not started: The topic is available to the user via the community, but the user has not completed any of the items in the topic.
in progress: The user has only completed some of the items in the topic.
completed: The user has completed all items in the topic
Note: If items are added to the topic after the user completes it, the user’s status remains “completed” in the report.
completed
Completed date
The date the user passed-completed the topic.
5-3-2021
Assessment user status
The user’s assessment status.
The available statuses are:
passed: The user has passed the assessment(s) in the topic.
failed: The user has attempted and failed the assessment(s) in the topic.
Not started: The user has started the topic but has not yet attempted the formal assessment(s) in the topic.
passed
Assessment completion date
The date the user passed the assessment.
3-3-2021
Raw Score
The total number of points the user has scored in their latest attempt on the assessment.
This score is not weighted by the formula set up in the assessment settings
10
Assessment result
The number of points the user has been awarded for their assessment attempt. The weighting is set by the admin in the assessment settings. The score is either displayed as a percentage or the total number of points the user has received.
The user’s score is only displayed as a percentage, if the ‘Show score as a percentage’ option has been selected in the ‘Assessment settings’ tab for the assessment.
100%
Nr of attempts
The total number of attempts from the user for the assessment.
1
Nr of completed questions
The total number of questions the user has answered in the assessment.
topic with the formal assessment. | 12345 | |||
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% |
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
Nr of incomplete questions
The total number of questions the user has failed to provide an answer for.
2
Q1 [question text]
The title should include the question id & text
The field itself should include the answer text of the user to the question
field title: “id: 2; you should pick up the phone to call
answer: yes
Marked as correct?
yes-no
If the Assessment user status for the user is 'Started' this column will show as N/A. | 10 |