I find this a rather nasty question to ask as it's basically using JIRA to produce a report in order to point fingers...but needs must and we have a renegade developer who needs to be reined in. We've been asked to provide some metrics!
Anyway, I want to produce a report which shows how many issues a developer has had assigned to them over the course of a project. That but was simple because I could use the "Assignee was [user]" query.
What I really need is to be able to query an entire project in one go so I can then produce a chart with the results but I can't work out how to do it. Any ideas?
Thanks in advance.
A couple of cents from me mother-goose..
You can use the Workload Pie Chart on your dashboard to represent your deviant's portion of bugs against the rest of the team.
Create and save a filter. If you want to get a cross section of bugs acroos all projects then you can omit the Project parameter. You can also add in other users to compare against.
issueType in (bug,"Story bug") and assignee was in (user1, user2, etc)
Add the Workload Pie Chart gadget to your dashboard,
specify your saved filter,
set it to group by assignee and
select the time field to report on.
This will give you a pie chart of the time spent on bugs for each user represented in a pie chart. It is a good idea to use a comparisson to your other devs.
Hope this helps
when I understand your question the right way, this is very simple. You have two alternatives.
project = [project code] AND issuetype in (Bug, "Story Bug") and (assignee was user1 or assignee was user2)
project = [project code] AND issuetype in (Bug, "Story Bug") and assignee was in (user1, user2)
Hope that helps!
You see, just like you filtered to multiple issuetypes, you can filter to multiple users. But what you did is, that you queried for specified project, issue, user1 but then just for user2 without the specific context from before. You need to nest it the right way.
Sorry for the late reply, I've been on holiday.
Hmmm - the query works but I can't graphically represent my findings, that's a shame.
There doesn't seem to be any way to order the issues by "assingee was" . Never mind, thanks for the help, just seems like I am asking JIRA to do something it can't do - I can export the data and manipulate in excel or just work with the totals from the individual queries.
More information that might help here.
If I used these queries:
project = "Project A" AND issuetype in (Bug, "Story Bug") AND assignee was "User 1" project = "Project A" AND issuetype in (Bug, "Story Bug") AND assignee was "User 2"
I'd see issues returned for these specific users and those issues would only be from Project A. However, if I queried using the above string but modified to include two users...
project = [project code] AND issuetype in (Bug, "Story Bug") AND assignee was "User 1" OR assignee was "User 2"
...it would when return results for issues in Project A, B and C (which Users 1 and 2 are also on).
I don't get it....
Yeah right, this is like I mentioned it in my answer, but I missed the "was" operator. The charts can only group every issue, not split one issue in several groups. So you finally end up to filter by last assignee or use other ways to generate your charts. If you are using Confluence, you could combine SQL Plugin with charting macros. But then you can maybe use every other tool.
I think I get where the problem is using this query:
project = "Project A" and issuetype = "Bug" and assignee was in (user1,user2)
That query lists every issue that was assigned to those users but the problem is how to use that information in a chart because the "was assigned" clause can't be used in a chart I think.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....
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!
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