I want to create a JQL to extract the COUNT/NUMBER of issuetypes that was created monthly, yearly or weekly, all in one gadget or report.
I cannot find the functionality for GROUP and COUNT. Thanks
Hi @Shafieka,
Welcome to the Atlassian Community.
If you need only one issue type, you should be able to achieve this by using the Recently Created Chart gadget of Jira configured with a filter that returns the issues of that type and with Period set to Weekly, Monthly or Yearly.
JQL: project = myProject AND issueType = MyIssueType
This chart displays the count of issues created, and how many of them are resolved (in green color) and how many are not resolved.
If you need something more advanced, you could search for a plugin on Atlassian Marketplace that provides the gadgets you need.
If you plan to try a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that lets you generate all kind of multi-field statistics and display them in form of table, heatmap tables or charts of various types.
Here are some possible examples related to your use-case:
Danut.
Hi, @Shafieka
Welcome to the community!
I believe the standard Jira gadgets will not allow you to get the information in the way you are looking for. Even the 2-dimensional gadget does not offer aggregation options or customizations. If you are open to try a marketplace solution, I recommend Mindpro Insights. I work at Mindpro and I believe the app can help you with your requirements. The app is very simple to use and you can create a dashboard in seconds.
Just to illustrate that, based on what you mentioned, I created a dashboard where you can filter the dates at the top of the screen. I added a 2d table gadget configured to show issue types and creation dates, so you can have an overview of this information.
There are other gadgets you can add to the dashboard to help with this context, such as "Issue type Distribution" and "Created x Done" for example:
The gadgets are interactive, which means that when you click on a chart segment, the entire dashboard adapts to your filter. Over 50 gadgets (pre-loaded and custom) are available for you to choose, and the custom gadgets can also be added in Jira Standard Dashboards.
I hope that helps.
Regards,
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Shafieka welcome to the community!
JQL, while it looks a lot like (P-)SQL does not work the same way.
A JQL query will only allow you to get the set of data but not perform any functions on it like GROUP or COUNT.
You'll need to look at using either a gadget on a dashboard or perform some other calculations outside of the search. (Also I assume you mean issues and not issue types?)
Once you have a JQL that gets you all the issues that were created in the last month you can
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Shafieka , have you considered using a dashboard gadget for your needs? Maybe Created vs. resolved would be a good choice. The two-dimensional would be another good choice.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I will try it and respond later - thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.