Basically I am looking to find out out how many times an issue has undergone status changes "Functional Design Approved".
Hi Urmila,
Yes, you can look in the History tab under the Activity section near the bottom middle of the screen,
Ah yes that is the manual method to get the data. 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Welcome to the community !!
You can use Jira Rest API's to build your own custom solution to track count in each status for your issues, or explore a mktplace app for this requirement. If you are open to try one take a look at
The Status count report below shows how many time your issues have been in each status.
Also the app has 20+ reports to meet a variety of use cases. Do give it a spin.
Disclaimer : I am part of the app team for this add-on
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Urmila Ghosh ,
As a native Jira feature, you’ve already been advised to use the Activity tab. Unfortunately, that approach is fully manual and has to be checked per issue—there’s no way to generate an overall report.
If you’re open to using a third-party app, as a SaaSJet representative I can recommend Time in Status app.
You’ll want to focus on these reports:
Status Count — to see how many times an issue entered the Functional Design Approved status.
Transition Count — to review all transitions to/from Functional Design Approved.
Status Entrance Date — to check the date an issue moved into Functional Design Approved.
And, of course, the Time in Status report will help you measure the total time issues spent in Functional Design Approved.
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Urmila Ghosh ,
You can do this in Jira, but it depends how efficient and detailed you want the result to be.
You can open an issue and go to History / Activity → History to see every status transition (from → to, date, user).
This works, but it’s manual, slow, and inefficient if you need counts across multiple issues or a specific status like “Functional Design Approved”.
If you want this quickly and accurately, apps are the better approach.
This lets you generate a report showing:
Exactly when a status changed
From which status → to which status
Who made the change
This makes it easy to see:
How many times an issue entered a specific status (e.g. Functional Design Approved)
Total time spent in each status
You can view results as:
Columns (counts per status)
Rows (one row per status)
Both apps are also available together in the Issue Insights for Jira bundle:
Issue Insights for Jira
Summary:
Manual history = possible but painful
Apps = fast, scalable, and purpose-built for exactly this use case
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey @Urmila Ghosh
Welcome to the Community!
Checking the history tab for every single issue to count status changes manually is exhausting. While JQL can find issues that were in a status, it doesn't easily give you a count of how many times it happened.
If you are open to using a 3rd party app, Timepiece - Time in Status for Jira has a specific report for this case.
Timepiece's Status Count report is designed exactly for this need. You can simply select the "Functional Design Approved" status, and the report will show you a list of all your issues with the exact number of times each one entered that status.
It’s a great way to spot rework or process loops instantly. Timepiece also offers many other report types, including Duration, Transition, and Date reports, to help you analyze your workflow history from every angle.
You can check Timepiece on the Atlassian Marketplace. Hope this helps you.
Disclamer: Disclosure: I am part of the OBSS team, the developers of Timepiece.
Best,
Birkan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Urmila Ghosh
Welcome to the Atlassian community.
Are you working with Jira Data Center or Jira Cloud?
Jira does not have a native report for how many times an issue has been in a status.
There are third party apps that could help with that. Are you open to getting a third party app to solve your requirement?
You could also develop a custom solution that leverages the Jira API.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.