Looking for JQL help with endOfDay

[Jason Arseneau]

Is it possible to track how many tickets that are not in a Closed or Resolved status at the end of each business day across multiple days

[Irfan Mazli Mazuki]

Hey Jason, maybe this JQL can help. It will essentially show the tickets created in last 1 day that are not in the Closed or Resolved status:
{code}
created >= -1d and status not in (Resolved, Closed)
{code}

Alternatively, you may use this JQL to see tickets that were created last 1 week that are not in the Closed or Resolved status:
{code}
created >= -1w and status not in (Resolved, Closed)
{code}

You may refer to Advanced searching - functions reference to know more in details of the JQL functions.