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")
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.
Sorry, no, I cannot. It is not a use case in my company so I haven't had to find an actual solution. If you do an internet search for "jira report on tickets created during time of day" or something like that then I'm sure you'll find other community posts and maybe even links to apps in the marketplace.
Calling all Confluence Cloud Admins! We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events