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

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • 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

Need A report that number of days ticket has been open

We need to generate A report that number of days ticket has to be open in an excel sheet .

2 answers

@Yogesh Mude 


I highly appreciate for your prompt response . Can you please help me briefly as i'm new to scripting where can I encrypt this code .


Thanks & Regards,


HI @Mahesh Kallepalli 

You need to use the script runner add-on for it.

If you have already then you can use the Admin --> manage app -->script field --> chose custom script field.

Once you added to choose the Duration as a template and then add the script into it and try.


Like Mahesh Kallepalli likes this

@Yogesh Mude 


Shall We need to create one custom field ?

@Yogesh Mude 


How it exactly works I created field with code as you mentioned . please find below screen shot . That field is displaying 0 minutes


HI @Mahesh Kallepalli 

Have you modified that code, you need to provide the status name to which you need the duration?

Example: Open status.

Once the ticket is created wait for some time and the transit the ticket to another status and then check, it should show the time duration.

@Yogesh Mude 


Yeah I have changed status to open and waited for some time and transit the ticket to another status . Please find attached screen shot it is not displaying any duration just able to see empty beside that field .duration.PNG

@Yogesh Mude 


Have you got chance to look into that above screen shot , Duration time is not displaying .

Hello @Mahesh Kallepalli 

You can use Time in Status for Jira Cloud to generate the reports you are looking for.

In fact, you can see the report on how long your issues have been staying in their statuses right after opening the add-on. You can choose the time format, for you I think "Days Hours Minutes" will give you the results you want to achieve.


With this add-on, you can generate Time in Status, Status Count, Transition Count, Assignee Time, Average Time, Status Entrance Date, and Time in Status per Date reports.

Also, this add-on has an advanced filtering system: by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).

You can export all the data as an excel file and use it for further analysis.

Try the add-on for free, hope this will help you.

@Julia Denys [SaaSJet] 


Thanks for your response we got to know about this add-on earlier we have implemented and shown to client but they are not good to purchase.

Suggest an answer

Log in or Sign up to answer
Community showcase
Asked in Jira Service Desk

Calling all Mindville Insight users, we need your help! (there might be swag involved)

Hello Insight users,  As part of our (Mindville's) acquisition by Atlassian, our training team is looking to build some new Insight training materials and we want to hear from you!  ...

276 views 4 6
View question

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