Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

View information as table and generate reporting/exporting

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

 

2 answers

1 accepted

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.

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

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.

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,664 views 22 33
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you