Count number of reported issues based on Epic Link

[Allen Chun]

Hi Atlassian Community, 

I would like to display a pie chart in my JIRA dashboard that shows number of reported issues based on Epic Link. 

For Example: 

Epic A: 
User A = 3 Reported Issues 

User B = 5 Reported Issues



I'm thinking something like this. 

issuetype = Idea AND project = "Idea Board"  AND "Epic Link" = IB-16 

But I want to count all issues by Reporter

What JQL should I use for this?

[Mitchell Davison [EY] · Accepted solution]

Hi Allen,

ScriptRunner provides a number of functions that you can use in JQL. IssuesInEpic will allow you to show the issues in a particular Epic and you can then display this in numerous JIRA gadgets based on Assignee. This should achieve what you’re trying to display.

[Allen Chun]

Hi @Mitchell Davison [EY] thanks for your response. I will try out this ScriptRunner addon, but is there a way I can just use a non addon JQL? 

Basically a JQL that counts the number of issues reported by a reporter in an Epic.

[Mitchell Davison [EY]]

You could just use the Epic Link to hang the tickets off and then report against that Filter for Assignee. That may provide the information you need.

[Sean Binny]

If you are using Jira Cloud, consider using the free jira addon "At a glance DevOps Dashboard for Jira". One of our chart shows you reported issues count and break down by Epic or Component and by user. Please see attached screenshot and help video.

Please reach out if you have any questions.