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

[xinan liu]

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]

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]

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.