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

Joshua Young February 8, 2024

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

 

 

1 answer

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 8, 2024

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 February 9, 2024

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. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events