JQL to group by status

[Janakiraman Perumal]

Hi All,

I am having the requirement to send the ticket count by grouping the status and send consolidated mail to team. By using the Lookup I can send the consolidated mail but im unable to group the tickets by status count and send in mail. Please help me

Hi,

     Comments not updated for below jira tickets past 3 days. Kindly take necessary action.

Ticket	Priority	Description
XXX	Critical	ABCD
XXX	Critical	EFGF
XXX	Major	HIJK
PENDING -2,  ON Hold - 2, Open - 4
Thanks, Automation Team

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

JQL finds issues, it has nothing to say about how they are presented in whatever you are reporting them in.

You need to look at the reporting functions - does the one you are using have any grouping functions?

[Janakiraman Perumal]

Hi All,

Something we need to send a consolidated mail like this. Can anyone please help me on how to get the status count. Im using lookup option to list the tickets

Hi,

     Comments not updated for below jira tickets past 3 days. Kindly take necessary action.

Ticket	Priority	Description
XXX	Critical	ABCD
XXX	Critical	EFGF
XXX	Major	HIJK
PENDING -2,  ON Hold - 2, Open - 4
Thanks, Automation Team

[Danut M _StonikByte_]

Hi @Janakiraman Perumal,

You can easily get the count by status by using the Issue Statistics gadget.

If you want to see the evolution/trend in time of these numbers, try the Cumulative Flow Diagram (CFD) gadget offered by our Great Gadgets app. It is highly configurable, supports various calculation methods.

This app offers many other gadgets that you and your team will find useful. Take a look on our blog to make an idea about how this app can help you.

I hope this helps. 

Thank you,

Danut Manda

[Marc - Devoteam]

Hi @Janakiraman Perumal 

As @Nic Brough -Adaptavist- mentions JQL finds information in Jira.

You can look on the marketplace form Atlassian for apps that can provide this information on a dashboard or apps that are able to export information from Jira to a reporting application like PowerBI or else.