I am severely math challenged and have a large hole in my skull from banging it against the wall. Is there a way to take data from Jira and calculate it for display in Confluence?
Scenario: Take the last 7 days ticket Resolved - ticket Created = TAT and then add all tickets from the last 7 days and divide by number of tickets the average.
Thank you very much
Hi @Lisa Tritt ,
You need to use additional apps to use math formulas in Confluence.
For example, the Table Filter and Charts for Confluence app.
The first step is to insert the Table Toolbox macro on the page and paste the two Jira Issues macro inside its body ("wrap" your Jira Issues macros in the Table Toolbox macro).
Use the following JQL for the Jira Issues macros:
project = project_name and updated >= -7d
Then your issue sets will be always up-to-date.
SELECT "Number" as 'Jira Issues', T1.'Count' as 'Created for the past 7 days' FROM T*
Here we got the total number of the Created for the past 7 days issues and set an additional column for further purposes.
SELECT "Number" as 'Jira Issues', (T1.'Count Done'+T1.'Count Fixed') as 'Resolved for the past 7 days' FROM T*
Here we got the number of the Resolved for the past 7 days issues, in our example this total number consists of the Done and Fixed issues.
SELECT *, (T1.'Created for the past 7 days'-T2.'Resolved for the past 7 days')/5 AS 'New counted value'
FROM T1 OUTER JOIN T* ON T1.'Jira Issues' = T*.'Jira Issues'
Here we merge the two tables and use our final formula to show the New counted value (one value minus another and divided onto some average value).
The formulas are used just to show an example of calculations in Confluence tables. You may use any math sequences as you need for the case.
I've just noticed that the number of the fixed issues for the Resolved for the past 7 days issues is fewer than for the created - don't pay attention on this. It's our test demo project, so I've used other JQLs for my Jira macros (not the 7 days ago, but weeks for the created issues) to get more or less corresponding numbers for the example.
And here you'll find more examples of calculations and visualisations using the Jira Issues macro https://docs.stiltsoft.com/display/public/TFAC/Using+Table+Filter+and+Charts+in+Combination+with+the+Jira+Issues+Macro
You may just follow these examples step by step, the only difference will be in nesting of the macros through the Table Toolbox macro as I've shown on the screenshots above (the new Cloud editor doesn't support nesting anymore).
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
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