How can I get count of tickets by category in email

[Kalyani Dronavalli]

I am trying to send a daily report to my Manager showing the ticket count by category through email.

Ex:  Status Category.   No of tickets

[Sachin Dhamale · Accepted solution]

@Kalyani Dronavalli ,

Welcome to the Atlassian Community.

If you only want to send the count per category then you can configure the automation rule

like this

Accept the Answer if it helps

[Kalyani Dronavalli]

@Sachin Dhamale 

Here the requirement is to send an automated daily notification with the summary of Issues with the status breakdown

• No.of issues that are OPEN
• No.of issues that are IN PROGRESS
• No.of issues that are AWAITING FOR APPROVAL
• No.of issues that are on HOLD

1. Open - 10
2. Inprogress - 15
3. Awaiting for Approval - 20
4. Hold - 5

[Sachin Dhamale]

@Kalyani Dronavalli ,

like i mentioned You can write the Schedule automation rule which will send email at schedule time.

You can create separate automation rule for each JQL Staus= Open/InProgress/ Hold etc.

If you want to send details of issue then like @Nic Brough -Adaptavist-  mention you can create filter and subscribe it

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4

[Stephan Maass]

Is it possible to do that on Jira Data Center?

[Nic Brough -Adaptavist-]

Yes, since well before Jira diverged into three (soon to be two) branches.

[Stephan Maass]

I do not have a "lookup issue" action aviable on data center.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Run a search for the issues you want to report on, save it as a filter, and then subscribe your manager to it, they will get a regular email containing the count of matching issues and the list of the keys for the first handful of them.