Assignment Detail by User Report

The Assignment Detail by User report details what content has been assigned to learners. You can filter data by date range, audience, individual user, assignment title or category. This report does not show canceled one-time assignments. This report is a Skillsoft template reportClosed These reports contain all data and activity going back to your initial contract start date with Skillsoft. Because the data in these reports is stored in our data warehouse, you cannot get up-to-the-minute information. Use these reports for trending and year over year analysis. These are flexible reports that allow you to create and save a customized view for later, as well as download and share it. but does contain near real-time data.

If you remove a learner from an audience that has an assignment and the learner has not completed the assignment, the assignment no longer displays for the learner in their assignment list and they no longer show in assignment reports.

If you remove a learner from an audience that has an assignment and the learner has completed the assignment, the assignment remains in their assignment list and their completion remains in assignment reports.

Report Insights

This report shows you:

  • A list of all users with active assignments including details about that user.

  • Details about the user's assignment including the assignment status and due date.

Get Started

To access the report and customize it for your needs:

  1. From the left navigation bar select Analytics, then select the All Reports tab.
  2. From the Assignments section, select Assignment Detail by User.

  3. To see just the data you need, specify global filters for this report. You find all filters under the Filters drop down.

    You can filter data on this report by date range, users or audiences, assignment titles and categories.

    What you select for filters here impacts what you see on the rest of the page.

  4. After you set filters, select Apply filters to update the data shown on the page. If you want to reset filters, you can select Reset to default.

After applying global filters, the table loads with a default set of columns presented in a default order. To use your data in a way that makes the most sense to you, you can organize the columns in the table by sorting, filtering, changing the order, and choosing which ones to display. You can also pin columns and group by them.

To create and save your own view of the Assignment Detail by User report:

  1. The following options are available to organize the columns in the report:

    Column Action How to Use
    Sort From within the column heading, select the arrow button to toggle between ascending and descending.
    Filter

    To filter a column for select data, from within the column heading:

    1. Select the more options button , then select the filter button .
    2. Choose how you want to filter. Options will vary depending on the data contained in that column. You may see: equal, greater than, less than, not equal, contains, does not contain, starts with, ends with, or in range.
    3. Enter a value in the space provided. This field is case sensitive. For example if you select contains and enter akara,Percipio does not find a match with and item containing Akara.
    4. If available, you can add more filters using the inclusion of AND or OR. If you select AND, data must meet both conditions to display. If you select OR, data must meet at least one condition to display.
    5. The filter is applied immediately. Select anywhere outside the filter to close the filter box.

    If a column is filtered, the filter icon shows in the column header.

    Pin (Anchor)

    To pin or anchor a column so that it does not scroll left or right off the page:

    1. From within the column heading, select the more options button .
    2. Make sure the more options tab is highlighted and select Pin.
    3. Choose Pin left or Pin right. If you select Pin left, the column is moved to the far left. If you select Pin right, the column is moved to the far right.
    4. To remove the pin and reposition the column back to its original location, select No pin.
    Autosize

    If you want to ensure you can read the longest value within a column, you can autosize it. You can do one column at a time or all of them at once.

    1. From within the column heading, select the more options button .
    2. Make sure the more options tab is highlighted and select Autosize this column or Autosize all columns.
    Group

    Sometimes it is helpful to see your data grouped in a particular way, for example, by user role or by status. You can create groups within groups for further segmentation.

    There are two ways to group your data:

    1. From within the column heading:
      1. Select the more options button .
      2. Make sure the more options tab is highlighted and select Group by [this column]
      3. To remove the grouping: select Ungroup by this column.
    2. From the right column expansion list:
      1. Locate the column in the list you want to group by.
      2. Select and hold the group icon group icon, array of gray dots.
      3. Drag the column to Row Groups at the bottom.
      4. Select the X next to the Row Group to remove it.
    Hide/Show

    To only show the data relevant to your needs, you can select which columns display.

    From the right Column expansion listClosed Column expansion list:

    1. Locate the column in the list you want to show or hide.
    2. To show a column, make sure you check the box. To hide a column, uncheck the box.
    Reorder To change the display order of the columns, you can click and drag a column heading left or right to reposition it within the table.
  2. To save this exact view of the report for future use, under Actions, select Save as new template.
  3. Enter a Template name for this report. The saved report displays under the Journeys reports section on the All Reports tab.

You can select to Download report at this point so you can share with others in your organization.

You can choose to create a report schedule. Under Actions, select Create report schedule. When you schedule a report, the report runs automatically and you get notified by email when it is available to view.

You have the option to do any of the following with a saved custom report template:

Filters

Filters you can set for this report include:

  • Date Range: Filters the data by a specified range of dates that you select from the drop-down list. When you select the date range, you must also select the type of report you want to see. You can choose up to three of the following options:
    • Launched: Select this option to only show assignments that launched within the specified date range. As long as the assignment launched within the date range, you will also see learners who completed it and who are overdue.
    • Due: Select this option to only show assignments that have a due date within the date range selected. With this option selected, you can choose dates into the future.
    • Completed: Select this option to only show assignments that were completed in the date range selected.
  • User filters: Under the Users filter option, you may see options for Audiences and Users. Select the plus to expand the option you want to specify. Search for the audiences or users you want to see, then select them from the list. You can perform multiple searches and make multiple selections and see them on the Selected tab. When you are done selecting all audiences or users, select Apply filters to return to the main filter list or expand the next filter group.
  • Include Inactive users: Select if you want to include users whose account status has been set to inactive because they left the company or went on leave.
  • Assignment filters: There are two filters under this section. Use these filters if you want to just review specific assignment titles or categories of assignments. Select the more arrow next to the option you want to specify. Search for the item(s) you want to see, then select them from the list. You can perform multiple searches and make multiple selections and see them on the Selected tab. When you are done selecting all items, select Add more filters to return to the main filter list.

Columns

Default Columns

The following columns are displayed by default in the Assignment Detail by User report:

  • FIRST NAME: The value entered in the First name user attribute. Usually the user's first name.
  • LAST NAME: The value entered in the Last name user attribute. Usually the user's last name.
  • EMAIL ADDRESS: The value entered in the Email address user attribute; the user's email address.
  • USER STATUS: The user's status within the system. Values include Active or Inactive.
  • ASSIGNMENT TITLE: The title of the assignment that contains the content item. If the content item is in more than one assignment, each assignment is listed separated by a comma.
  • DUE DATE: The date the assignment is (or was) due.
  • ASSIGNMENT STATUS: The status of the assignment based on user progress (Started, Not Started, Complete) unless the assignment is archived, then it shows Archived.You may also see a status of Waived if an admin waived an occurrence of a recurring assignment for a learner.
  • ASSET TYPE: The type of asset. Types may include assessment, audiobooks, audio summaries, books, book summaries, course, journey, linked content, scheduled content, dynamic content, video, and module. When you select module or video, only items launched stand-alone display in the report. If you select Course: child content ( videos and modules) viewed as part of a course display in the report. You can choose to display both and then select to display the column, Consumed in Course, to determine how the item was launched.When you see the asset type for linked content, it could be associated with any of following Skillsoft content types: AI simulator, cheatsheets, interactive courses, test preps, labs, bootcamps, partner content and any custom content items you added. When you see the asset type, scheduled content, it could be associated with any of following Skillsoft items: live courses or live events. When you see the asset type, assessment, it is associated with the content type of Skill Benchmarks. The module asset type refers to individual components of Skillsoft courses that are in HTML format.
  • CONTENT TITLE: The title of the asset. If the course is offered as a language equivalency, you will see the title of the course for last language equivalency the learner started.
  • STATUS: The status of the content based on user progress. The status is not impacted by the Date filters. For all content items you could see Started or Completed. For live courses, you may also see the following values in the Status column: Registered, Approval pending, Canceled, Denied, and Wait listed. When learners restart a course, you see either Restarted or Completed.
  • COMPLETED DATE: The date in UTC the user completed the content. This date is not impacted by the Date Range Presets filter. You may see completion dates outside your Date filters if there was any type of asset activity within the selected date range. The time stamp of t00:00:00Z is expected.
  • ASSIGNED DATE: The date when the assignment was assigned to the user.
  • ASSIGNED BY FIRST NAME: The first name of the user who assigned the content.
  • ASSIGNED BY LAST NAME: The last name of the user who assigned the content.
  • OVERDUE: A No value indicates that the user did complete the assignment. When an assignment status is incomplete, a Yes value indicates the user did not complete the assignment by the specified due date.
  • SCORE: The score the learner achieved on the content.
  • LEARNING HOURS (HOURS): The total number of hours a learner spent in content learning. If the item is a Skillsoft course, the total includes time spent watching videos while in the course (not the time spent on the same videos if launched in video-only mode) and working on knowledge checks within the course. If you see learners with a completed status and with 0 duration, the learner only took the test and did not watch any of the content. Time is listed as fraction of hours. Something that takes 90 minutes to complete is listed as 1.50 and something that takes 15 minutes is listed as 0.25.
  • ESTIMATED DURATION (HOURS): Total estimated amount of time it takes a learner to complete the specified content. For online courses this only includes the video playback time. Time is listed as fraction of hours. Something that takes 90 minutes to complete is listed as 1.50 and something that takes 15 minutes is listed as 0.25.

The following columns are also available in the Assignment Detail by User report:

  • USER UUID: The UUID of the user.
  • LOGIN NAME: The value entered in the Login name attribute for the user.
  • USER ID: The value entered in the User ID field. It is used to identify a user inside Percipio.
  • ASSIGNMENT UUID: A unique identifier for a specific assignment.
  • LANGUAGE CODE: The language of the asset. Available languages and their codes are listed here.
  • CONTENT UUID: A unique identifier for a specific content asset. Content UUIDs are mapped to activity codes in SumTotal Learn and are also used with third-party learner management systems.
  • CONTENT ID: Unique identifier for the Skillsoft content item. If the course is offered as a language equivalency, you will see the UUID of the course for last language equivalency the learner started.
  • ASSIGNED BY USER ID: The User ID of the user who assigned the content.
  • ASSIGNED BY USER UUID: The UUID of the user who assigned the content.
  • BUSINESS OBJECTIVE: The business objective that is linked to the assignment. For a complete listing of available business objectives, see Create a New Assignment.
  • LEARNING HOURS (SECONDS): The total number of hours a learner spent in content learning. If the item is a Skillsoft course, the total includes time spent watching videos while in the course (not the time spent on the same videos if launched in video-only mode) and working on knowledge checks within the course. If you see learners with a completed status and with 0 duration, the learner only took the test and did not watch any of the content. Time is listed in total seconds.
  • LEARNING HOURS (HHMMSS): The total amount of time learners spent in content learning during the specified time frame. If the item is a Skillsoft course, the total includes time spent watching videos while in the course (not the time spent on the same videos if launched in video-only mode) and working on knowledge checks within the course. If you see learners with a completed status and with 0 duration, the learner only took the test and did not watch any of the content. Time is listed in (00h00m00s) format.
  • ESTIMATED DURATION (HHMMSS): Total estimated amount of time in hours, minutes, and seconds, it takes a learner to complete the specified content.
  • ESTIMATED DURATION (SECONDS): Total estimated amount of time it takes a learner to complete the specified content. Time is listed in total seconds.
  • CREATED DATE: The date the assignment was created.
  • User Attributes (varies): These fields are defined by (and are unique to) your organization. For more information, see User Attributes. If you are using an attribute type of Percipio User, the value in the field can be either first and last name, email address, login ID, or external user ID. The value that appears depends on what has been specified for the individual user.