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

This widget could not be displayed.

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 Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

120 views 1 3
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