Reporting on % tickets moved by Target Date

[Swati Rathore]

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?

[Kevin Bui]

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.