JQL query, to keep point in time query

Question

Hi,

I am doing graphs on the status of tickets at the start of every month and saving them to their own page. For a graph around the count of open tickets, and let's say I have a tab for issues open in Jan/2024, any issues fixed today, will still reflect in the Jan/2024 graph, meaning they will become less and less and not a true reflection of the issue open then regardless of what has changed after.

As an example, this is what I am using for tickets open at the end of June 2024

project = X AND status in ("Awaiting Action", "In Progress", Reopened) AND created <= 2024-06-30

John Funk · Answer

Hi Paul - Welcome to the Atlassian Community!

I think this is what you are looing for:

project = X AND status was in ("Awaiting Action", "In Progress", Reopened) ON 2024-06-30

Mohamed Benziane · Answer

Hi,

You can use "created <= endOfMonth()"

Cristian0791 · Answer

Hi Paul,

Please try:

project = X AND status in ("Awaiting Action", "In Progress", Reopened) AND and created >= startOfMonth()

This should bring you the tickets created in the current month.
Each month it will bring you new created tickets.