I would like to create a report for a particular issue type to identify a count that was created mon

[Shafieka]

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

[Danut M _StonikByte_]

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. 

[Eduardo Anflor - MindPro]

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

[Dirk Ronsmans]

@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

• use a few of the gadgets to get you the data
• use a build in report with a series of Created issues
• use an automation to send you an email with the information (there the JQL can be used to lookup the issues and do some  calculations on it)
• you can also use the rest api to pull the data from Jira (using the JQL in a search endpoint) and then process the data outside of Jira
• or of course look in to an app that can provide some reporting functionalities

[Jack Brickey]

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.

[Shafieka]

I will try it and respond later - thanks