I'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:
Does anyone know how to create a calculated attribute for the contact rate buckets outlined above?
Hi Brittni Nowell - you might want to check this article on how to get started with custom metrics and attributes https://support.zendesk.com/hc/en-us/articles/4408839385754-Getting-started-with-custom-metrics-and-attributes
Thank you @jahn11. 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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.