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

[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.