Calculate Days Since Ticket Creation in Zendesk
How do I calculate the number of days since a ticket was created in Zendesk?
To calculate the number of days since a ticket was created, you can use a Standard calculated metric in Zendesk Explore.
Use the formulaDATE_DIFF(TODAY(),[Ticket created - Timestamp],"nb_of_days")to determine the difference between today's date and the ticket creation date. This metric can then be added to your report to track the time elapsed since ticket creation.
More related questions
How can I create a report to find out when an organization last submitted a ticket in Zendesk?
To create a report showing when an organization last submitted a ticket, you'll need to use Zendesk Explore. Start by opening the Reports library and selecting 'New report'. Choose the 'Support - Tickets' dataset and begin building your report….
What skill level and time commitment is needed to create a Zendesk ticket report?
Creating a Zendesk ticket report requires a moderate skill level and about 20 minutes of your time. You'll need access to Zendesk Explore Professional or Enterprise, and you must have Editor or Admin permissions. With these prerequisites, you can…
What permissions are required to create a report in Zendesk Explore?
To create a report in Zendesk Explore, you need Editor or Admin permissions. These permissions allow you to access the necessary tools and data within Zendesk Explore Professional or Enterprise to build and customize reports, such as the one…
Can I exclude tickets without an organization from my Zendesk report?
Yes, you can exclude tickets without an organization from your Zendesk report. When adding the 'Requester organization name' attribute to the Rows panel, you have the option to exclude NULL values. This ensures that only tickets associated with an…
What is the purpose of using the SUM aggregator in a Zendesk report?
The SUM aggregator is used in a Zendesk report to total the values of a metric, such as the number of days since a ticket was created. By setting the metric aggregator to SUM, you ensure that the report calculates the total number of days across…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
