Weighted Jira Statistics

Question

Hi community,

I am figuring out whether I can do some calculation on statistics from JIRA, and show them in the Confluence page as a table.

For example, I want to get a weighted score on overall status.

Open*0, In-progress*5, Done*10

So if there is 5 open tickets, 2 in-progress ticket, and 1 done tickets.

I should get a table that shows the number of each kind of tickets, and the overall score 20, like below.

Please help providing a method to accomplish so.

Thanks you.

Katerina Rudkovskaya _Stiltsoft_ · Answer

Hi @Kevin Lin,

You may look into the following standard Confluence macros to show info from Jira on Confluence pages:

Jira Chart – Two Dimensional Chart (creates an aggregated tabular view of your Jira issues, not very flexible).

Jira Issues (creates a non-aggregated tabular view of your Jira Issues: each row relates to a specific issue, you can also choose what fields you want to pull from Jira yourself).

The latter macro can be aggregated as you need with the help of the Table Filter and Charts for Confluence app (this is our add-on and it supports dynamic Confluence macros). Please check our Pivot Table macro – it may help your case.

And here you may find several examples of the dashboards in Confluence created with the help of the Jira Issues macro and our app.

Aron Gombas _Midori_ · Answer

One way to do this:

* Export to Excel with this app
* Add the formula in Excel
* Attach the Excel file to a Confluence page and display it with the corresponding macro

You can even create a custom Excel template that will save step 2 and produce the Excel file with the pre-calculated statistics.

For example, here is a template calculates "created" and "resolved" over time by aggregating them by year, month and day:

(Discl. this is a paid and supported app that we develop.)