Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Epics how long in development?

Hi! does anybody know if there`s a way to find epics which are in development more than certain time? ex. more than 4 weeks? 

thanks

Wojciech 

4 answers

Hi @Wojciech Cora ,

When youy transition the issue to in development you should fill in a date field with current date. 

And you could use a query like 

issuetype = epic and status = "In Progress" and "Waiting since" <= endOfDay(-28) 

Regards

Dave

Thanks Dave I see you understand my point. I was trying to use filter:

 

project = [name] and issuetype = epic AND Sprint = [number] and [number] and status != done

 

it is showing me some data but I see they are true`ish... true to some extent... 

meh.. 

Hi @Wojciech Cora ,

Thanks for posting in community.

I am not sure of how your workflow is configured.

  1.  What are the status for WIP items in your board?
  2. Are you using EPIC STATUSES in your epics? 
  3. Are you using roadmap? Check this out as you can see your EPIC Movement - https://support.atlassian.com/jira-software-cloud/docs/see-the-progress-of-an-epic-on-the-roadmap/

It would be great if you could respond to the above to answer your query.

Cheers

Suvradip

Thanks, no worries. I will manage :)

W

Ok No worries @Wojciech Cora .

But the criteria of the JQL would depend on answers to these(because writing a JQL doesn't help us to find the solution until we know how these projects are configured e.g. - EPIC STAUSES one of the field used). More Over, Road maps would be the better option if enabled instead of using writing JQL because the roadmap was created to check the EPICs completion.

Hi @Wojciech Cora 

How about using JQL, such as:

project = myProject
AND issuetype = Epic
AND statusCategory = "In Progress"
AND NOT status CHANGED AFTER -4w

Please look here for more information on advanced JQL:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

Best regards,
Bill

Hi @Wojciech Cora ,

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

For you specific case, you can export the report into excel and sort results by "In development" status duration.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

126 views 1 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you