Need to find common issues by client

Good afternoon -

I have a query question, perhaps one of fine folks could assist.

We use Jira as an organization to track all issues, across the board. After a couple of months using it, I would like to generate a list of common issues by client.

For example, let's say that Client A had a file that failed within our Application, this happened 4 times over the past month and an issue was opened up for each occurence.

What I would like is to be able to list those issues quantitatively.

So, the query would return the following:

Client A - Bad File - 4

Where "Client A" represents the client, "Failed File" represents the issue type, and "4" represents the number of tickets opened under that issue type.

I know there should be a simple Jira-SQL answer to this but I am not familiar enough with the format of their language to intuit what I need to do.

1 answer

1 accepted

0 votes

There isn't really a "count" function, but

It does depend on how exactly you are trapping the information (exactly what data is going into what field), but it sounds like you could do this in either simple or advanced (JQL) filters. You filter for "issuetype = bad-file and client = A and created > -1m" (that assumes client is select list of some sort, but you could be using reporter, component, etc).

You can then display information on filter summaries on your dashboard with "filter statistics". In fact, it might be more useful to drop the "client" clause in this case, and then you can tell the filter statistics to summarise by "client" and it will tell you things like "client A had 4 issues, client B had 6 and client C had 1"

Awesome! I'm going to dig in and see if I can get this to work!

Thanks,

Josh

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,755 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot