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
...
| Info |
|---|
Notes:
|
Column | Definition | Example |
|---|---|---|
User id | The unique identifier of the user who has access to the Formal Assessment | 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 |
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. | 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:
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 |
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. | 2 |
Nr of correctly answered questions | The total number of questions in the assessment that the user has answered correctly. | 2 |
Nr of incorrectly answered questions | The total number of questions the user has answered incorrectly in the 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 | yes |