TicketMetrics
Columns
Name
Type
References
Description
Id [KEY]
Long
Automatically assigned.
TicketId
Integer
Tickets.Id
The ID of the associated ticket.
GroupStations
Integer
Number of groups this ticket passed through.
AssigneeStations
Integer
Number of assignees this ticket had.
Reopens
Integer
Total number of times the ticket was reopened.
Replies
Integer
Total number of times ticket was replied to.
AssigneeUpdatedAt
Datetime
When the assignee last updated the ticket.
RequesterUpdatedAt
Datetime
When the requester last updated the ticket.
StatusUpdatedAt
Datetime
When the status was last updated.
InitiallyAssignedAt
Datetime
When the ticket was initially assigned.
AssignedAt
Datetime
When the ticket was last assigned.
SolvedAt
Datetime
When the ticket was solved.
LatestCommentAddedAt
Datetime
When the latest comment was added.
FirstResolutionTimeCalendar
Int
Number of minutes to the first resolution time inside and out of business hours.
FirstResolutionTimeBusiness
Int
Number of minutes to the first resolution time inside and out of business hours.
ReplyTimeCalendar
Int
Number of minutes to the first reply inside and out of business hours.
ReplyTimeBusiness
Int
Number of minutes to the first reply inside and out of business hours.
FullResolutionTimeCalendar
Int
Number of minutes to the full resolution inside and out of business hours.
FullResolutionTimeBusiness
Int
Number of minutes to the full resolution inside and out of business hours.
AgentWaitTimeCalendar
Int
Number of minutes the agent spent waiting inside and out of business hours.
AgentWaitTimeBusiness
Int
Number of minutes the agent spent waiting inside and out of business hours.
RequesterWaitTimeCalendar
Int
Number of minutes the requester spent waiting inside and out of business hours.
RequesterWaitTimeBusiness
Int
Number of minutes the requester spent waiting inside and out of business hours.
CreatedAt
Datetime
When this record was created.
UpdatedAt
Datetime
When this record last got updated.
Url
String
The API url of this ticket metric.
Last updated