nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Levente Szabo _Midori_

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.

All comments

Levente Szabo _Midori_

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:

Screen Shot 2020-01-07 at 14.31.50.png

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

Best,

Roberts // support@eazybi.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server