JQL query, to keep point in time query

[paul carr]

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]

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]

Hi,

You can use "created <= endOfMonth()"

[Cristian0791]

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.