For the past 1 year I need to find the number of issues created in different time range say between 2 am to 3 am, 3 am to 4 am and so on....
So the ask here is to find issue created based on time range.
What will be the JQL for that?
Hello @Manish Sonowal
Welcome to the community.
I don't believe there is a JQL that can be used in the Free JIRA Cloud version to get you this information.
I don't work with the Free version, so I'm not sure about what you can do to augment it with regarding to adding apps or customizations. One customization you could investigate is 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.
Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...
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