Display the age of a ticket in a query

[Phil]

Is there a way to display in a result set, the age of a ticket. For example in JQL, I return all the open tickets of a project in a filter. Is there a way to add a column to display the age of that ticket (Current Date - Created Date)?

[Bill Sheboy · Accepted solution]

Hi @Phil 

Not with the built-in features of Jira.

One would need a marketplace addon / app which extends the features of JQL (e.g., calculated fields), or add a custom field and use an automation rule to populate it daily.

Kind regards,
Bill

[Phil]

Thanks Bill

[John Funk · Accepted solution]

Hi Phil,

What I usually do is create a custom field of number type. Then create an automation rule with a Scheduled trigger that runs daily and records the diff between the current date and the created date in the custom field. Then you can put the custom field in a filter or dashboard, for example. 

[Phil]

Thanks John

[John Funk]

You are welcome. 

[Rahul_RVS]

Hi @Phil 

If you would be interested in a mktplace solution to get this data, you can try out our app.

Time in Status Reports 

You can easily group your statuses in the app to extract issue age / cycle times etc very easily.

Also this app you can generate time in each workflow status for multiple issues with multiple filter and grouping options. The app has 20+ reports to meet a variety of use cases.

More details here.

Disclaimer : I am part of the app team for this add-on

[Phil]

Thanks

[Iryna Menzheha_SaaSJet]

Hi @Phil  👋

Great question — while Jira's native JQL doesn’t allow dynamic calculations like "Current Date - Created Date" to display a ticket’s age in the filter results, there are two great workarounds using solutions (developed by my team) that make this super easy:

1. Time in Status 

With Time in Status, you can:

• See how much time each issue has spent in every status

• Calculate total time since creation (age of a ticket)

• View this as a table, chart or dashboard and export it if needed

It’s a great way to answer:

“How long has this issue been open?”
“Which issues have been sitting in ‘To Do’ the longest?”

---

2. Time Metrics Tracker | Time Between Statuses.

If you want maximum precision, this app is the way to go.

With Time Metrics Tracker, you can:

• Choose whether a metric starts from the first transition to a status or the first transition from a status – perfect for aligning with your team’s real process flow

• Build multiple custom time metrics for Lead Time, Cycle Time, Wait Time, SLA-like calculations, and more

• Visualize them together in one report, filter by project/sprint/assignee, and export to Excel

• Gadgets for Jira dashboards:

  - Histogram gadget – visualize how many issues fall into time buckets (e.g. 0–2 days, 3–5 days, etc.)
  - Table gadget – display calculated metrics as columns, grouped by assignee, project, or sprint
  - Scatter Plot gadget – analyze the correlation between time spent and story points, complexity, or other fields

📌 Example:

It’s perfect for monitoring overdue tasks or tracking internal deadlines based on lifecycle stages.

---

Both tools support filters, dashboards, exports, and visualizations — and can show ticket age as a column, which is exactly what you're looking for 😊

Let me know if you’d like a demo or a report example!

[Ayça Erdem_OBSS_]

Hello @Phil 

If you're looking to display the Issue Age the total time an issue has been open since its creation  you can easily do this using Timepiece - Time in Status for Jira, developed by our team at OBSS.

Using the Duration Between status, you can define a metric that includes all statuses an issue can go through while it's considered “open.” This column will sum the time spent in those statuses, giving you the exact age of each issue up to the current moment.

Unlike Jira’s native capabilities, which don’t allow for displaying dynamic date-based metrics like “Created to Now,” this approach gives you a live and accurate Issue Age  ideal for backlog management, SLA tracking, or identifying aging tickets.

The app uses existing Jira issue histories, so you don’t need to make any changes to your workflows. Reports can be accessed through the Timepiece reporting page, dashboard gadgets, and issue view tabs, and they support both tabular data and charts. You can also integrate with other systems via REST API or export to CSV/XLS formats.

Timepiece is available for both Jira Cloud and Data Center. Let me know if you’d like help setting up the Issue Age report or if you need anything else!

Hope it helps,
Ayça

[Danut M _StonikByte_]

Hi @Phil,

This is not possible with Jira's default toolset.

As advised already, you could try adding a custom field for that and populate it by implementing automation rules. 

Another way would be to use an app from Atlassian Marketplace that is capable to calculate and display the age of the issues. 

If you intend to try an app, our Great Gadgets app offers some gadgets that can display this info for you in dashboard gadget. For example, the WIP Aging Chart gadget displays the issues from a filter/JQL by their age (can be configured like time since creation) in a plot chart. 

On its Data tab it lists the issues along with their age. This tab can be easily exported in CSV.

You can also use Control Chart gadget or Histogram Chart gadget offered by the same app for this purpose. Find more in this article: https://community.atlassian.com/forums/Jira-articles/Building-a-powerful-Kanban-dashboard-in-Jira-with-Great-Gadgets/ba-p/1664331

Danut.