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.
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.
If you also use reporting in Confluence Server, you can work with the Jira Issues macro in combination with the Table Filter and Charts app.
Using the Table Transformer macro, you can count the number of people per project:
Use the following SQL query:
SELECT 'Component', COUNT (DISTINCT 'Assignee') AS 'Number of People' FROM T* GROUP BY 'Component'
Hi @Brian Barnes ,
If you are using MySQL you could use something like :
component.cname as 'Component name',
COUNT(DISTINCT cwd_user.ID) 'Number of people'
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.
This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...
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