How to report how many tickets were submitted in a certain time period?

[Joshua Young]

I'm trying to generate a report for how many tickets have been submitted within the last hour of the day on a specific day of the week. Specifically, I want to know how many tickets were submitted in the last hour of every Friday. 

I'm familiar with filters and dashboards, but the common issue I am running into is that the gadgets in the dashboard need a field that is usually input by the end user. Also, on the places that I can look at the created date, I can't filter for the created time. 

Any advice would be welcome, thank you

[Jack Brickey · Accepted solution]

Maybe the following JQL. You may need to tweak to meet your definition of the last hour of the work week

project = abc and created >= startofweek(88h) and created < startofweek(89h)

Start of week is Sunday midnight 

88h is Friday 4pm

89h is Friday 5pm

[Joshua Young]

Thank you! This has set me on the right track, I was able to use that to pull the correct tickets for the week. My next goal is to adapt this and get the the total of those tickets for the year. For all of 2024, I need to report how many tickets were created on Fridays between 5pm and 6pm. 

I've tried to add: AND createddate>='2024-01-01' AND createddate<'2024-02-09', to the end of the sequence. This didn't work because it brought the same results due to the original JQL.