Need JQL to filter all tickets of past 4 months created between night 10 PM to 6 AM IST

binay_yadav

Use case:

I am trying to create a chart to get all the tickets created between night 10 PM to 6 AM IST, the chart should have months in X axis and count in Y axis. Data needed for past 4 months.

I tried using the below mentioned JQl but it only returns me ticket for one day and the same is required for atleast 4 months.
project = L3I AND created > startOfDay("-2h") and created < startOfDay("+6h")

Trudy P Claspill

Hello @binay_yadav 

Welcome to the community

I don't believe there is a JQL that can be used out of the box for JIRA Cloud to get you this information.

You could probably find an app to add to your JIRA instance that would help with this. Alternately you could investigate adding a custom field to track the hour of the day when an issue was created, and seeing if you can set that field for each issue using the Automation feature to evaluate the Created date/timestamp.