JIRA tasks that have transitioned in last 30 days

I would like to present activity by showing the number of tasks that have transitioned over the past XX days.

Ideally, this could be captured in a filter that could then be displayed in a gadget on the dashboard in a variety of ways.  Would be good to know what status the task is currently in, and when it transitioned to that state (and where from would be nice, not necessary)

2 answers

2 votes
status changed after -Xd

where X is the number of days. You can change it to hours weeks etc. You can also add FROM, TO, BY clauses and other JQL functions to narrow the result set.

If you need to see the old status, you will have to check the change history, unless you capture it in some custom field.

Note that the 'status changed after -Xd' solution (which will indeed give you what you asked for) only captures that the status was changed, not if it was changed multiple times and if so, how it transitioned. You need to look at the history for each ticket, either on the screen or build something using the REST API (or more complex solutions).

Also, if you have a transition that has the same start and end status (in effect going back to itself), it won't be tracked this way. Not sure how to do that (or if that was even part of the original question :o) .

Interesting comment about the same status transition. Haven't checked that scenario before!

As an example, I can see this being used as a rudimentary form of approval process, have a 'loopback' transition "Approve" available to a special 'approvers' group or role of users (setting a somewhat - but not completely - hidden field 'approved by' to currentuser in a post-function) and open the transition out of the status once the 'approved by' has been populated.

If someone edits the field manually, you have the History as proof. Not bulletproof, but good enough for most, I believe.

Other variations than approval would be if a certain group has to decide on a specific field value before the issue is allowed to proceed in the workflow. Maybe Product Managers have to populate a Business Value or Priority.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

189 views 1 11
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you