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..

Access this report

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.

    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. Your options include:
      • Assignments launched within the date range: Select this option to only show assignments that launched within the specified date range.
      • Assignments due in the date range: Select this option to only show assignments that have a due date within the date range selected.
      • Assignments completed in the date range: 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 more arrow next to 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 Add more filters to return to the main filter list.
    • 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.

    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.

  5. 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.
  6. You can select to Download report at this point so you can share with others in your organization.
  7. 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.
  8. If you save the initial custom view, you can then:

Default Columns Displayed

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.
  • DUE DATE: The date the assignment is (or was) due.
  • RECURRENCE: The number of times a learner returned and re-completed the content.
  • ASSIGNMENT TYPE: The type of assignment, either One time or Recurring.
  • ASSIGNMENT STATUS: The status of the assignment based on user progress (Started, Not Started, Complete) unless the assignment is archived, then it shows Archived.
  • ASSET TYPE: The type of asset. Types may include assessment, audiobooks, audio summaries, books, book summaries, course, journey, linked content, scheduled content, dynamic content, module, and video. 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 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 learning in this content item. If the item is a Skillsoft course, the total includes time spent watching videos, working on knowledge checks, and taking tests. 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.

Other Columns Available

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 learning in this content item. If the item is a Skillsoft course, the total includes time spent watching videos, working on knowledge checks, and taking tests. Time is listed in total seconds.
  • LEARNING HOURS (HHMMSS): The total amount of time users actively used the content during the specified time frame. 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.
  • 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.