My group uses (a single) field, Target Date, to track when the ticket is expected to change statuses.
I would like to do reporting on how many of our tickets across the portfolio are changing status based on Target Date, monthly. Any thoughts?
Hi @Swati Rathore - I don't believe this is possible. JQL can do things that are similar, but not quite the same.
Like if it was a specific date you wanted to compare against, you could run the following search:
project = "My Project" AND status changed to "Done" BEFORE "2020/01/15"
Or if it was a timeframe you wanted to compare against, you could run this:
project = "My Project" AND status changed to "Done" BEFORE -1w and AFTER -2w
But I don't think JQL can compare against a date in a date field. At least, not out-of-the-box. You might be able to accomplish this using a Marketplace app though.
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