Query for how many issues were flagged in a particular month

Question

Hello, i am trying to search a query that will provide me with flagged issues for a particular month.

For example: how many issues were flagged in the month of January. The only dates available on my filter results are: updated date, created date and last status change on date.

Thanks

Javan

John Funk · Answer

Hi Javan - Welcome to the Atlassian Community!

Unfortunately, there is no history function on the Flagged field. So getting Flagged = Impediment will only show you issues that are currently Flagged, not issues that were Flagged at anytime during the month, year, etc.

So, you will probably need to create a custom field (hidden from the Edit and View screens) and set a value for the field when the Flagged field is updated to Impediment. Then you simply run a filter for the value of the custom field and your date ranges.

Craig Nodwell_7eve9b · Answer

Hi @Javan Asimba welcome to the community.  
You can't get directly to this but you can find some ways around it.
You can try something along these lines (of course you can change the date function)
Example:
Flagged = Impediment AND updatedDate >= startOfYear()

Mohamed Benziane · Answer

Hi,

Welcome to the community

This is not possible, you can't find out when a issue was flag using JQL, you will need to look at the history of each issue.