How can I create a report that shows how many people are assigned to each Component?

Question

I'm looking for an answer on if I can generate more numbers based / analytical reports.  I've only been able to figure out how to basically display issues in different ways, based on filters.

What I want to do, for example is have a graph that shows how many people on my team are assigned tasks that are tagged with each Component value.

For example:

Component 1 - 3 people

Component 2 - 6 people

Component 3 - 1 people

I'm open to displaying this in different ways, but some kind of graph would be nice.

Natalie Paramonova _Stiltsoft_ · Answer

Yes, sure you can make charts out of that data and actually use the Jira Issues macro to create almost any reports and charts in Confluence.

To display Confluence pages in Jira you can use Confluence Page Gadget (here you can find information about its adding).

Antoine Berry · Answer

Hi @Brian Barnes ,

If you are using MySQL you could use something like :

SELECT 
component.cname as 'Component name',
COUNT(DISTINCT cwd_user.ID) 'Number of people'
FROM jiraissue 
JOIN project ON project.ID = jiraissue.PROJECT
JOIN nodeassociation ON jiraissue.id = nodeassociation.source_node_id
JOIN component ON nodeassociation.sink_node_id = component.id
JOIN cwd_user ON jiraissue.ASSIGNEE = cwd_user.user_name
WHERE project.pkey = 'Your project key'
GROUP BY (component.ID)

If you want to go further you can use a reporting tool such as SSRS.

Antoine

Brian Barnes_sfq79d · Answer

That looks neat.  Thanks!  I guess there would also be a way to make a chart out of that data as well?  Also, is there a way to display the data in a JIRA dashboard, or would it only work in Confluence?