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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Transition history


Does anybody know how to extract the whole so that I can analyze it? Transitions history.JPGtransitions history to a spreadsheet file?

5 answers

4 accepted

2 votes
Answer accepted
Bloompeak Support Marketplace Partner Sep 16, 2021


The data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json, then you need to calculate it by coding which parses issue history rest api json for each issue.

Or you can search for marketplace apps which does the same for you. One of them is  Status Time app developed by our team. It provides reports on how much time passed in each status, status entry dates and status count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try without installing the app.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.


Excellent! Looks to be what I´m looking for. I´ll try it. Thank you very much!!

How can I get the <api_token> in order to use the  Jira Rest API?

Bloompeak Support Marketplace Partner Sep 17, 2021

Assuming you are using cloud, you can create api token from your profile page.

Like Vronik likes this

Got it. Thank you!

Like # people like this
0 votes
Answer accepted
Rahul_RVS_Support Marketplace Partner Sep 17, 2021


As an alternative you can also look at our plugin to get this data. 

Agile Tools : Epic Tree & Time in Status 

The Time in Status module of the app provide the status transition count report along with other important features, as below to track time and manage issue hierarchies

1) Time in Status :- More than 7 types of Time in Status reports to track your issues.

2) Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features

3) Timesheet :- View/Enter your time spent for multiple days

4) Links Hierarchy :- View/Manage roll up for hierarchy (up to 10 levels), based on your Issue Links parent child relationship.

5) Epic Hierarchy :- View/Manage roll up for standard Jira hierarchy. Epic -> User Story -> Subtask


Time in Status.png

0 votes
Answer accepted
Hana Kučerová Community Leader Sep 16, 2021


in addition what @Fabian Lim said - what kind of analysis would you like to perform? Maybe we can give you better tips, if you share us more about your use case. Thank you.

considering the workflow, it should follow straigh forward till the end. For instance, when I have a transition from UAT back to Development phase, probably it means that I have a defect. Counting the number of times I have the flow going back in the workflow, I could analyze the situation and maybe define an action plan to improve the process. Further, I can evaluate the time spent in each event.

JIRA Transitions History Analysis.JPG

I would like to see this kind of information

0 votes
Answer accepted
Fabian Lim Community Leader Sep 16, 2021


Out of the box you can't. I would consider searching on the marketplace for apps that analyze transitions. E.g. when they were moved and how long they stayed in a specific status, who transitioned it.


1 vote
yuliia_b__SaaSJet_ Marketplace Partner Sep 17, 2021


If you need to get transition history you can also check out Issue History add-on. 

You'll get a history journal for every activity and find out:

  • What changes were made to the issues
  • The date when modifications occurred
  • Which user has made the changes

For further analyzing you can export it to a spreadsheet or excel file. 

issue history export.jpg

If you need to know how many times an issue was transitioned from one status to another, the Transition Count report of Time in Status for Jira Cloud app will be handy. 

These apps are developed by my team, so let me know if you have any questions.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events