XP Detailed Report

The XP Detailed report provides details as to how and when users are earning experience points (XP) and how many they earn.

Learners and admins earn XP for completing content and performing tasks that help promote learning activities. You can set the amount of XP users earn and then track them with this report.

By default all site admins can view the XP Detailed report. You can grant other admin roles access to this report through Role customization.

Report insights

The XP Detailed report shows you:

  • A list of active and inactive users in the platform who earned XP including when they earned them, what they earned them for, and how many points they earned.
  • For each activity or category where users earned XP, there is a new row in the report.
  • You can use this report to determine the winner of a contest. Maybe you ran a promotion and the person earning the most XP in the month of July would win a prize – this report gives you that information.

Access this report

The platform may take up to 24 hours to include relevant activity in this report. You can see at the top of the report when the data was last updated.

To access the XP report and customize it for your needs:

  1. From the Analytics menu in the left navigation bar, select All reports.
  2. From the Activity section, locate and select XP Detailed report. The report displays with default filters selected.

    The filters you set apply to all data presented on the page. If your filters are too broad, allowing for an excessive amount of data, the report may stall. If this happens, adjust your filters and rerun. This may occur, for example, if your date range is too large. To use filters:

    1. Change the default filters by selecting an option from each filter you require.
    2. Select Run report. The report loads to match your filters.
    3. If needed, reset both global filters and any filters made to columns by selecting Clear all filters. To reset the full report back to its original state, select Reset to defaults.

  3. After applying 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.

    4. 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,the platform 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.
  4. To generate a CSV file for further analysis, select Download report. If you chose to download the report, a message displays with a link to the Reports download tab. Select it to view the CSV download progress and/or open the CSV file.

Filters

Report filters include:

  • Date Range: Filters the data by a specified range of dates that you select from the drop-down list.
  • Audience: Predefined group of users. Enter the name of an audience and then select it from the list. You can display the data for multiple audiences at the same time by entering more than one audience name. You can select up to 20 audiences.
  • User: Individual with a Skillsoft Platform user account. Enter a user's name to filter the report to include that user. You can display data for up to 20 users at the same time by typing in more than one user name.
  • Show Inactive: Select if you want to include users whose account status has been set to inactive because they left the company or went on leave.
  • Content filters: Select from categories that earn XP, such as completing an asset, making an assignment, or sending reminders. If you do not select a category, the reports include all categories by default.

Columns

Default columns

The following columns are displayed by default in the XP Detailed 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.
  • AUDIENCE: Predefined group of users. The name of the audiences for which this user is a member.
  • ROLE: The user's Skillsoft Platform role. Valid values are: domain admin, site admin, learning admin, manager, content coordinator, content curator, and learner.
  • XP CATEGORY: What the user did to earn points. Learners typically earn points by completing content items; Managers and admins earn points for completing tasks like making assignments or running reports. You can set the amount of points for each activity.
  • XP EARNED: The total number of experience points your users earned for the category they completed.
  • XP EARNED DATE: The date the user earned the XP.

Additional columns

Other columns not shown by default, but available for selection include:

  • USER UUID: This is a universally unique identifier that is automatically assigned by the system for each account.
  • 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 the platform.
  • USER STATUS: The status of the user in the platform. Valid values are active or inactive.