Can I create a pie chart showing issues belonging to different groups?

I'd like to add a pie chart to my dashboard that runs of a filter of open issues, and is broken up by the group of the reporter. Is this possible? Basically I want to be able to see how many open issues belong to each department (and each department has been set up as a group).

Maybe there's a better way to do this? It doesn't have to be a pie chart, but I don't want to just have a bunch of individual filters if I can avoid it.

4 answers

0 votes
Thomas Schlegel Community Champion Feb 19, 2012

Hi,

you can create a pie chart with the charting plugin (https://plugins.atlassian.com/plugin/details/288)

That should do it.

Best regards

Thomas

In case of the reporter belonging to multiple groups, how can this distribution be done? A workaround could be to have a custom field which contains a Group name along with the Assignee and plot with the custom field. O course which means that when the Assignee changes, the group also should be changed to have the data right.

Otherwise run an SQL query on the Jira database and plot the results in a chart in Confluence (if you have Confluence also)

I had a custom field before that was checkboxes for "department," and if an issue had more than one department identified, it was just counted once in each "pie piece". I'd imagine it would work the same for this. Each group is a department, and so if a user was in multiple departments (which doesn't actually happen, but just for the sake of argument) then any issue they report would show up for each group that they're a member of.

If the pie chart in a PDF document is equally acceptable (instead of having this right in the Dashboard), then you can easily implement this with the PDF View Plugin.

  1. Just pass all open issues to the plugin (use the standard issue filter),
  2. iterate over the issues,
  3. for each issue check to which groups its reporter belongs to,
  4. increment a counter in a (group-name) to (counter) mapping (use a Multimap to simplify your life),
  5. finally transform this map to a BarChartDataset and render the chart!

You can take the plugin's sample bar chart as starting point:

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Thursday in Jira

Updates to jira.atlassian.com give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

487 views 1 14
Read article

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