Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I would like to create a filter for tickets created between certain times of day

Joey Moroney January 20, 2021

Does anyone have a formula for creating a filter that specifies a time range. Ie: Incidents created between 5pm - 9am 

As we have night staff and day staff I need to create a dashboard for ticket timings between each team 

2 answers

0 votes
KAGITHALA BABU ANVESH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2021

Hi @Joey Moroney ,

 

created >= startOfDay("17h") And created <= endOfDay("+9h")

I think the above will work, please check this

0 votes
KAGITHALA BABU ANVESH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2021

Hi @Joey Moroney ,

 

createdDate >= "2021-01-21 17:00" and createdDate <= "2021-01-22 09:00"

But everyday have to change the date manually. will check if any  other solution is possible. 

Suggest an answer

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

Atlassian Community Events