Skip to main content
Loading...
Skip to article
  • Qualtrics Platform
    Qualtrics Platform
  • Customer Journey Optimizer
    Customer Journey Optimizer
  • XM Discover
    XM Discover
  • Qualtrics Social Connect
    Qualtrics Social Connect

Ticket Reporting Datasets


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About Ticket Reporting Datasets

Ticket reporting datasets are the ticket fields you can report on in your dashboards; this includes information like status, ticket owner, priority, and so on, but it also includes various ticket data.

Based on your organization’s needs, you can make multiple, separate ticket reporting datasets. This is so you can separate ticket data by the different programs or teams working out of your Qualtrics brand, limit the number of fields each team has to navigate through, and restrict a user’s access to data based on the program they belong to.

This feature is only available to Brand Administrators, CX Administrators, or users with Qualtrics Ticket Admin permission enabled.

Qtip: This feature moved ticket data mapping from the dashboard to the Follow Up page.
Attention: You can have a maximum of 10 ticket reporting datasets across your organization.

Creating Ticket Reporting Datasets

Using the Default Dataset

The default dataset is created when ticket reporting is enabled for your brand. If your brand had ticketing enabled but not ticket reporting, then any tickets created before ticket reporting was enabled will not be included in the default dataset. To incorporate tickets created before the dataset was generated, you can adjust the tickets’ statuses.

You can use the default dataset in your dashboard if it contains all the fields you need for your reporting. However, if you need to display additional fields in your dashboard, then create a custom dataset.

Using Custom Datasets

Before you can set up ticket reporting, you must create a ticket reporting dataset.

Ticketing data starts being recorded the moment the first dataset is created, meaning that when this is mapped to a dashboard, the data starts on the date of dataset creation. Once a dataset is created, the ticket data for all fields in the dataset will be available to use in a dashboard. If you create additional datasets and those datasets reuse fields from a previous dataset, then the data from those fields will be readily available to use in a dashboard. Any newly added fields that do not exist in any other datasets will not have data available to use in the dashboard until a ticket with that field is created or updated.

Qtip: If you have used ticket reporting before, there will be at least one ticket reporting dataset to start.
  1. Go to Tickets.
    Tickets from the global naivgation menu
  2. Click Tools.
    Once on ticketing page, open the Tools menu. Ticket reporting datasets is the fourth option
  3. Select Ticket Reporting Datasets.
  4. Click Add a dataset.
    Big tile-style button that has a plus sign in the middle and says "Add a dataset"
  5. By default, all available metadata fields and ticket data will be added. Add and remove fields as needed.
    Data mapper has a list of fields inside
  6. When you have configured your fields, make sure you add Ticket Data Restrictions. This determines who has access to a given ticket reporting dataset.
    Qtip: See the Ticket Data Restrictions section for more detailed steps.
  7. When you’re finished, click Save.

Mapping Ticket Fields

See a list of all available metadata fields.

Qtip: Any edits you make to a field will not be reflected in other datasets where that field occurs. Edits are always dataset-exclusive.

Attention: A ticket must be created with your new ticket data field before you will be able to add it to a ticket reporting dataset. For example, if you add a ticket data field to a ticket and immediately try to map it to a ticket dataset, you will not be able to select the new ticket data field. Once a ticket using the new ticket data field is created, you’ll be able to add it to a ticket reporting dataset.

  1. Click on the Add Field button.
    Add button bottom-left; on a field, its a space for a name, the field type, then the gray button for mapping that turns blue once a field is mapped
  2. Provide or update a Field Name for your field.
  3. Select the Field Type.
    Qtip: Field types define the type of data mapped into the field and consequently determine which widgets will be available for each field. If you don’t see your desired Field Name when selecting the source of a widget, you may need to change the field type or use a different widget. Be aware that changing Field Types can break widgets on any Dashboard using the affected fields. As such, we often recommend adding a new field that maps to the same question rather than editing the Field Type or Field Mapping of existing Fields (e.g., you may have a Text Set field for a NPS group as well as a separate Number Set field for a NPS value).
  4. Click on the Not Mapped box, and choose the ticket data that will populate for this field.
  5. Click on the Save button at the bottom right.

Moving and Removing Fields

Hover over a field. The move icon to the left can be used to drag and drop the field around the mapper. The delete icon ( X ) can be used to remove the field from the ticket reporting dataset.

Icon like a hamburge for moving, X icon for deleting. Both show to left of a field when hovered over

Qtip: Removing fields from your mapper will affect all widgets using fields from that dataset. You will also affect which users are able to edit, use, or view those fields in that dataset. It will not affect the data saved with tickets themselves.

Recoding Ticket Data

If the values of your ticketing fields don’t look correct – for example, labels being misspelled or wrongly capitalized on the dashboard, or numeric values not aligning as expected – you can recode them. To do so, open a ticket reporting dataset, find the field that you want to recode, and click the arrow to open the recode editor. Note that not all fields can be recoded.

Recode button looks like an arrow next to mapping

In the Recode Editor window that opens, specify the fields and their values. On the left, under Label, include the value as it currently appears in the ticket data (i.e., on the dashboard). On the right, under Recode, enter what you want to correct the value to.

Window opens where you can define labels and how they should appear in the data mapper

Recoding ticket fields works similarly to recoding fields in the Dashboard Data tab.

Ticket Data Field Types

Field types help you define the format of the data so the dashboard knows what widgets it can be added to. Field types for ticket data are similar to the field types for other dashboard data, but with a few key differences.

Field types dropdown in ticket data mapper

  • Date Calculation: Create custom fields that allow you to measure the time between different ticket statuses. See Time Between Ticket Statuses for more details. Anything you create here will generally have the same widget compatibilities as regular date fields.
  • Drill Down: Nests multiple text set fields to allow you to drill into multiple levels of data. Corresponds to drill down field groups in the dashboard data editor.
  • Field Group: A group of numeric values or number sets with the same scale. Corresponds to measure groups in the dashboard data editor.
  • No Multi-Answer Text Set option.

You can consult the Field Type & Widget Compatibility Table when deciding what widgets to build with the data available.

Ticket Data Restrictions

By default, all users and roles have access to all ticket reporting data. However, you can create ticket data restrictions to limit access to this data.

Attention: All users in the brand are able to export ticket reporting data. Changing export permissions for the dashboard will only affect exports of dashboard data and will not affect the ability to export ticketing data.
Qtip: This works similarly to other data restrictions.
Qtip: Be thoughtful about the ticket data you allow users to access. If there are sensitive ticket fields you don’t want shown to users, consider limiting access with ticket data restrictions.
  1. Select Ticket Reporting Datasets.
    Inside ticketing page. Tools menu opened and ticket reporting datasets option highlighted
  2. Select a dataset.
    Datasets listed as tiles on the page
  3. Click Ticket Data Restrictions.
    Ticket Data Restrictions upper-right
  4. Click Add user or role.
    New window where you can add users and roles
  5. Type the name of the role or user, and select them.
    Search bar for finding roles; on the right, next to an added role, text in blue that says "all data"
  6. Click All Data.
  7. Click Add Restrictions.
    Another new window opens. In the center is a button for "add restrictions"
  8. Select a field to restrict access by. This can be a default ticket field, like status or priority, or custom ticket data.
    Selecting ticket data fields from the dropdowns
  9. Choose between the following:
    • Is: Enter a static value the ticket field has to match.
    • Matches user attribute: Determine a User Attribute that the ticket field has to match. This is best for values that vary by user.
  10. Select the value that must be matched.
    Allow rollup data is selected
  11. Select whether to allow rollup data. See linked page for details.
  12. Click Done.
  13. Click Done.
    Blue buttons bottom-right corner
  14. Click Save.

Using Ticket Reporting Datasets in Dashboards

Once ticket reporting datasets have been assigned to a user, they can go to the Ticket Data section of the dashboard settings to select the dataset they’d like to use in their dashboard. Click Add data to get started.

Center of ticket data page, blue add data button

The user can then proceed to create a ticket reporting page and add widgets to it.

Qtip: If a ticketing dataset you were using is deleted, you’ll have the opportunity to choose a new dataset, and will once again see the “Get started” screen shown above. If the previous ticketing dataset is deleted, you will need to manually fix any widgets you added to ticket reporting pages so they match the new dataset.

Swapping and Editing Datasets

Buttons in upper-right of ticket data editor

Once you’ve selected a dataset, you’ll be able to see the list of fields, but not edit them. To edit fields, use the Edit button in the upper-right. You’ll be taken to the dataset editor on the Follow Up page.

To switch your dashboard to a different ticketing dataset, click Re-map the data set.

Removing Ticket Reporting Datasets

Warning: Once you delete a dataset, its restrictions and customization cannot be retrieved. Only delete a dataset if you’re absolutely sure that’s what you want to do. You cannot delete the default dataset.
  1. Go to Tickets.
    Tickets from the global naivgation menu
  2. Click Tools.
    Once on ticketing page, open the Tools menu. Ticket reporting datasets is the fourth option
  3. Select Ticket Reporting Datasets.
  4. Hover over a dataset and click x to delete it.
    X upper-right of a tile representing a ticket reporting dataset

Editing Existing Ticket Reporting Datasets

  1. Go to Tickets.
    Tickets from the global naivgation menu
  2. Click Tools.
    Once on ticketing page, open the Tools menu. Ticket reporting datasets is the fourth option
  3. Select Ticket Reporting Datasets.
  4. Select a dataset. You will be able to edit mappings, restrictions, and other settings discussed on this page.
    Names of datasets