Count of users by contact rate last 30 days
RespondidaI'm trying to create a report to view unique users by the number of tickets they've created over the past 30 days. The goal is to count how many users in the past 30 days:
- Created 1 ticket
- Created 2 tickets
- Created 3 tickets
- Created > 3 tickets.
Does anyone know how to create a calculated attribute for the contact rate buckets outlined above?
-
HiBrittni Nowell- you might want to check this article on how to get started with custom metrics and attributeshttps://support.zendesk.com/hc/en-us/articles/4408839385754-Getting-started-with-custom-metrics-and-attributes
-
Thank youJahn Bronilla. Unfortunately, I don't think this answers my question. I need to create a calculated attribute for various ticket buckets. I've tried using the formula below but get the following error "(D_COUNT(End-user submitted tickets) can't be used in an calculated attribute, wrap it in an attribute fix or attribute add"
IF (D_COUNT(End-user submitted tickets)=1) THEN "1"
ELIF (D_COUNT(End-user submitted tickets)=2) THEN "2"
ELIF (D_COUNT(End-user submitted tickets)=3) THEN "3"
ELIF (D_COUNT(End-user submitted tickets)>=4) THEN ">=4"
ENDIF -
I tried copy and pasting your formula in "Calculated Metrics" instead of attributes and it actually work.
I just added Requester name and email as an attribute then filter it by created month.
Iniciar sesiónpara dejar un comentario.
3 Comentarios