I can find out how many critical bugs have been opened in the last month using a JQL query like
issuetype = Bug AND priority = Critical AND status in (Open, "In Progress", Reopened) AND created >= 2012-02-13
If I want to compare this figure, with the corresponding figure from last year, a naiive attempt at getting last year's equivalent might be
issuetype = Bug AND priority = Critical AND status in (Open, "In Progress", Reopened) AND created >= 2011-02-13 AND created < 2011-03-13
But of course this is completely wrong, because it will tell me how many critical bugs that were created between 2011-02-13 and 2011-03-13 currently have staus open, in progress, or reopened. What I want to know is how many of these bugs had such a status one year ago.
I don't know if the JIRA data model, allows such a query to be formulated, but if it does, I'd appreciate it if someone could show me how.
What I want to know is "on 2011-03-13 how many critical bugs created in the previous month have a status of Open / In Progress / Reopend on 2011-03-13. I don't think your query captures this, because it will wrongly include (for example) a bug that was created on 2011-03-01 and permanenty closed on 2011-03-02.
In other words, your query doesn't specify at what point in time the bug should have one of these statuses. I only want bugs that have one of these statuses on 2011-03-13 to be included.
Wow, I got swamped and now that I've finally gotten my head back above water, I find we have several new members! Welcome @Darren Keith lowman , @Amanda Babb , @Luis Zapata , @Joli Holmes , and @bh...
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