It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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 Leader 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 in Jira Software

[New] Jenkins for Jira Software Cloud and a way to connect your hosted apps

Jenkins is the leading open-source automation server used by startups and enterprise teams to build, test and deploy code to production.   We are excited to announce an official integration betw...

983 views 1 14
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you