How to Use JIRA & Confluence to Caculate This Kind of Statics?

Question

I want to know how to achieve this function by JIRA & Confluence.

* The average Resolution time of Project issues (in a month):

(ResolutionDate - CreatedDate)/Closed issue number(in a month)

* Ratio of issue Resolved by someone:

Resolved issues' number by someone/All the issues someone was assigned to

* Issues' number which Resolved by someone
* the number of every Developers which issue's ResolutionDate >= Duedate

Thanks very much!

CelesteCS · Answer

Hello!

The most convenient way I see is using JIRA Issues macro as a macro to get needed information from JIRA into Confluence and perform some post-calculations over it.

For any calculations in Confluence, including any manipulations with output of third party macros, like JIRA Issues macro, you may use CelesteCS Math for Confluence.

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.

Thanks!

Jason Plumhoff · Answer

There are probably several ways to get this information, but I found it easiest to use the Better Excel JIRA plugin to craft custom reports showing what I wanted to see.  The plugin lets you upload excel templates (with pivot tables, charts, etc.), and you can even have it fire off groovy scripts to do really involved calculations.