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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.