How to calculate Ticket Age in days using Ticket Created Date in Zendesk Explore?

Hello everyone,

I’m trying to calculate Ticket Age (in days) in Zendesk Explore by finding the difference between the Ticket Created Date and the current date.

🎯 Requirement / Logic

I want to:

• Subtract Ticket created date from Today’s date
• Get the result as number of days (Ticket Age)

🔍 What I tried

DATE_DIFF(TODAY(), [Ticket created - Timestamp], "days")

❗ Issue

I’m getting the error:

“Invalid time unit for the given dates”

(Attached screenshot for reference)

✅ Ask

• What is the correct formula to calculate Ticket Age in days in Zendesk Explore?
• Which function and time unit should be used (DATEDIFF, DATE_DIFF, etc.)?
• Should this be built as a standard calculated attribute or a metric?

Any working example or guidance would really help. Thanks in advance! 🙏