SquidSupport
Product reference / Reports

Ticket Fields report

In the app: Reports → Ticket Fields

Needs the 'View Reports' permission.

Shows how often each value of a custom ticket field was used: which order types, contact reasons or other values your team sets most, and how that changes over time. Ticket fields themselves are created under Settings → Custom Fields.

Field, period and store

The report looks at one field at a time.

  • Ticket field: the field to analyse. The menu lists the organization’s active custom fields; type to search. The first field is selected by default, unless the page was opened with another active field selected. Loading this menu also needs the "View Custom Fields" permission; without it, the page shows a field-loading error.
  • Period: two date fields for the first and last day, both included, or "7d", "30d" and "90d" for the last 7, 30 or 90 days. The page opens on the last 30 days. The end date cannot be after today.
  • Aggregation: "Day", "Week" or "Month" sets the size of the steps in the "Trend" chart. It does not change "Top used values". The default is "Day", unless the page was opened with a saved selection.
  • Store filter: appears when you have more than one store. It can include or exclude several stores.
  • "Refresh" reloads the report.

A value is counted in the period in which it was last set on the ticket, not by when the ticket was created. A field filled in today on a ticket from last month counts today. If the value is changed later, the ticket moves to the day of the change and counts under the new value only.

Days start and end in the organization's "Report timezone" from Settings → Organization; the line "Times shown in …" names it.

A teammate whose access is limited to certain stores only sees values set on those stores' tickets.

Unlike the other reports, this one does not leave out deleted tickets, tickets merged into another one or the example ticket: a value set on such a ticket is counted.

When the organization has no active custom fields, the page says "No custom ticket fields exist yet" with a link to Settings → Custom Fields. The report has nothing to show until a field exists and has been filled in on tickets.

Top used values

The 20 values that are set on the most tickets in the period, with the number of tickets and a percentage for each, and "Total" underneath.

  • Tickets on which the field is empty are not counted.
  • "Total" is the sum of the values shown, so with more than 20 different values it is lower than the number of tickets that have the field filled in.
  • The percentage is the value's share of that "Total", not of all tickets.

Click a value to see its tickets.

Trend

A line chart of the five most used values over time, one line per value, in steps of a day, a week or a month as chosen under "Aggregation". Each point is the number of tickets on which that value was last set in that step. Values outside the top five are not drawn.

Tickets behind a value

Clicking a value under "Top used values" opens a panel titled with the field and the value. It lists the tickets with that value: "Ticket" (number, subject and customer email, with a link that opens the ticket), "Assignee" and "Created".

The panel shows the first 50 tickets. "Download All tickets" downloads up to 5,000 tickets with that value in the period as a CSV file, newest by ticket creation date first. Despite the button’s name, any remaining tickets are left out.

Export CSV

"Export CSV" at the top downloads the tickets behind the whole report: every ticket on which the selected field was set in the period, for the stores in the filter, with the value. One file holds at most 5,000 tickets, newest by ticket creation date first. Empty field values are excluded. The button is disabled until a field is selected.