I want to display a count for jira bugs in confluence in form of a table. So far I was able to use the Jira Filter in Confluence to show the bugs in a table. Now I want to count the issues for each priority per week like this:
major trivial .....
week 1 23 2
week 2 22 5
How can I achieve this?
For example, for your case you may wrap you Jira Issues macro into the Pivot Table macro and create the required table (as we don't have different priorities for our project, I've chosen statuses instead but it doesn't matter - the macro works with all the Jira Issues columns and allows you to create different pivots like in Excel):
Hope this may help your case.
@Katerina Kovriga _Stiltsoft_ thank you very much! This helps a lot. But there is one problem. You used the created timestamp in the pivot table to filter the data per week. But then only the issues that are created are counted. My goal is to count the active issues. So when there is one issue on the board for 3 weeks I want to count it every week with the last priority or status it had. Is this possible?
I can come up only with the following workaround - you may use the cumulative running totals.
The Pivot Table is the same table from the previous answer.
Then go to the Table Transformer macro and type in the following custom SQL query:
SELECT* FROM (
SUM (TT2.'Count In Progress') AS 'Count In Progress Cumulative',
SUM (TT2.'Count To Do') AS 'Count To Do Cumulative'
FROM T1 AS TT1
JOIN T1 AS TT2 on TT1.'Created'::Date >= (TT2.'Created'::Date)
GROUP BY TT1.'Created')
ORDER BY 'Created'::Date ASC
And here is your result table with the running totals:
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