Creating a report that details total number of Service Request open on a specific date Edited

[Mike Kenneally]

I'm trying to create a report that will detail exactly how many requests were open on a given date. We already have a report will tell us how many tickets were created & resolved but not what the total of how many were open. 
Apologies, new to JIRA so looking for guidance.

Thanks 

[Jack]

how will you input the given date? If this is static and you just want to find everything created say yesterday...

createdDate >= startOfDay(-1) and createdDate < startofday()

or a specific day of say March 16, 2021...

createdDate >= 2021-03-16 and createddate < 2021-03-17

[Mike Kenneally]

Thank you for this - looking at my question again and I could have worded it better I think. I already have reports to provide how many tickets were opened and how many were resolved for last 7, 30 & 90 days. What I don't have is a way to report on how many Service Requests in total were open (so I guess in an Unresolved state) on a given date.

[Daniel Ebers]

Hi @Mike Kenneally

I could think of a query like the following which would show you the issues "In Progress" for a specific day:

project = DEMO AND status WAS "In Progress" DURING (2021-02-19, 2021-02-20)

Regards,
Daniel

[Mike Kenneally]

Awesome ! - thanks a bunch @Daniel Ebers 
That gives me what I'm after - is there a way to refine this to use the current date - 90 days and provide just a count for each day ?
Thanks