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

How do I write a report/filter that shows tickets assigned to me and resolved in a quarter

Hello. I do not know the reporting language at all, I've googled, but I am not finding what I am looking for.

Every quarter, I would like to run a report/filter to see list of all the JIRA tickets that were assigned to me, and that I resolved. So basically, If I run it on 10/1/19, for example, it will give me the applicable JIRAs tickets for the last 90 days.

However, If I run it on 10/18/19, I'd have to know how to specify the previous quarter, excluding the 18 days of October.

Thanks in advance to anyone who knows how to do this.

2 answers

1 accepted

1 vote
Answer accepted

You could use a JQL (Jira Query Language) query like

resolved >= 2019-07-01 AND resolved <= 2019-09-30 AND assignee in (currentUser())

A good trick to leave the JQL (jira query language) is to start by using the "basic" mode where you can use drop downs and such to build simple queries" and then switch to "advanced" so you can see the actual JQL that is generated.

(note: that query assumes that you were the assignee when it was resolved, and no one changed the assignee after the fact. If you resolved a ticket that wasnt assigned to you, or if someone changed the assignee after the fact, then this query would not catch it. Actually catching who made the transition would be trickier, and depend on your workflow)

Wow! That was quick.  Thank you very much, Andrew!

Stephen Wright Community Leader Oct 19, 2019

Just to add - you can history search on assignee - so if the assignee has changed, you could add "assignee was currentUser()" - finding both tickets which are and were assigned to you previously!

Ste

Thanks Stephen. I think the "was" is what I want.

Like Stephen Wright likes this

Hi ckf,
In addition to the suggested solution and supposing you are using Jira Server:


if you really want to query issues within real quartes (I mean not the last 90days) you can have a look to the endOfQuarter()  and startOfQuarter() provided by JQL Booster Pack (FREE) with allow you to dinamically query issues within the current or past quarters of year.

Hope this helps,
Regards

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

273 views 1 2
Join discussion

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