View information as table and generate reporting/exporting

[Matias Varela]

Hi, we need to see some details in a issue in a table format. For exmaple:

Status               Count                    Time

To do                    2                         10d

In Progress           5                         60d

Testing                  3                         20d

.                             .                           .

.                             .                           .

.                             .                           .

Also, we need to analyze, compare and reporting this information individually between different issues. For example, we´d like to analyze in an excel, gadgets, EazyBi, etc

Moreover, we have installed script runner add-on but we can't create a lot scripted fields to get this information one by one. Only we could create one scripted field.

Do you have any idea to manage this goal? 

Thanks!

Matias

[Levente Szabo _Midori_ · Accepted solution]

One way you can give a try to export and analyze your Jira information is Better Excel Exporter.
The app is highly flexible so you can customize your Excel reports with Groovy scripting to do complex data processing.

[Matias Varela]

Thanks for your help! Could you give an example how I can manage this with groovy and this add on? 

[Levente Szabo _Midori_]

I suggest you start familiarizing with the app here and then give the app a try by actually exporting your Jira data to Excel from the Issue Navigator for example and see how that works for you. Then reach out to us directly if you have specific questions regarding your use case, so we can help you.

By the way, here is a recent use case story of how a telecom company used Better Excel to build custom reports driven by their custom scripts.

[Roberts Čāčus - eazyBI]

Hi @Matias Varela 

It looks like you want to analyze the number of days an issue spent in a status and the number of times the issue was transitioned to the status.

If that is what you are looking for, then you can try to create a table report in eazyBI with the Transition Status dimension and the measures "Transitions to status" and "Days in transition status". Please have a look at the picture of a sample report below:

Let me know if I missed anything and you have any questions.

Best,

Roberts // support@eazybi.com