I am running into difficulty getting a line chart that plots two series:
issues created since the startofyear (increasing over time)
issues created this year are closed or moved to a specific status (decreasing over time)
Basically, my filter is:
Project = X And created >= startofyear() - This would be the first series to track the total count of newly created tickets this year.
Project = X AND created >=startofyear() AND status CHANGED TO 'Done' - THis would be series 2 to track the closure of items created this year.
Any ideas? There must be a way without going to a 3rd party gadget
Project in (LIST OF PROJECTS) AND status was in (New) after 2020-01-01 AND status was not in (New, "Dev Ready", "In Grooming", "On Hold", "In Development", Cancelled, "Dev Complete", "Ready for USGA Approval", Done) before 2020-01-01
I'm using this convoluted method of getting the date range I want because the JQL editor rejects the use of the createdDate field in combination with the "None" Time Series Field setting.
Gotta love when you get to post your own answer!
Doing more research I came across the following post:
This gave me the info needed to solve this. When you select "None" in the Time Series Field, the JQL editor inserts the necessary DURING statements (or so you'd think) to make your query work propery, but that is not the case. The DURING, by default, is only applied at the end of your query (as mentioned in that link). A fix was put in by Atlassian that allows you to insert placeholders for where the DURING statements should go, so you can put one after each condition in your query.
My query previously was:
Project in (PROJECT LIST) AND status was in (New) after 2020-01-01 AND status was not in (New, "Dev Ready", "In Grooming", "On Hold", "In Development", Cancelled, "Dev Complete", "Ready for USGA Approval", Done) before 2020-01-01
Leaving the JQL Editor to it's own devices, it will add (invisibly) a DURING statement only to the last condition in my query (after the final "before 2020-01-01").
Now that you can put placeholders $DURING in to force the JQL Editor, I was able to correct it as follows:
Project in (PROJECT LIST) AND status was in (New) after 2020-01-01 $DURING AND status was not in (New, "Dev Ready", "In Grooming", "On Hold", "In Development", Cancelled, "Dev Complete", "Ready for USGA Approval", Done) before 2020-01-01 $DURING
Hope this helps someone that hits a similar issue (like me) and isn't a developer (also like me).
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