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

Question

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.

Midori · Answer

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.

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

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

Justin Corcoran · Answer

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.

Renjith Pillai · Answer

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)