Community
Q&A
Jira
Questions
How can I find the number of working days a ticket has been in its current status

How can I find the number of working days a ticket has been in its current status

Hi,

I have been trying to find a way to display the number of working days that a ticket has been in its current status on a filter - e.g. ticket 1 is currently in New status and has been in New for 4 working days, ticket 2 is in Resolved and has been for 10 days.

I have been trying with JQL but cannot find a way to calculate the days since status change - only the total open time as a column on the filter results. I did a bit of reading on similar tickets, which would seem to indicate this is not possible with JQL alone. Any help or suggestions appreciated.

Thanks!

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

Answer accepted

Create a filter like this (with approrpiate number of days):

status changed after -10d

You can save the filter and use it another query.

issue not in filter_saved_earlier

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Thanks - it took a few filters but its a great roundabout solution.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

How can I find the number of working days a ticket has been in its current status

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events