custom reports - Issue type and how often it has changed status

[Max_Clark]

Hey guys im very new to reporting in jira have done a bit in service now but it seems very different

im looking to make a report that tracks how many initiatives (or any issue type) has moved status that month or week etc

any help it appreciated

[John Funk]

Hi Max,

Do you have specific statuses in mind? For example, you can write a query like this:

Project = ABC and issuetype = Initiative and status changed to "In Progress" after startOfMonth()

This will show all Initiatives that changed to In Progress this month.

[Hannes Obweger - JXL for Jira]

Hi @Max_Clark

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the time of transition from [status] to [status], the number of transitions from [status A] to [status B], and many more. Combined with JXL's advanced features such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc.

Any questions just let me know,

Best,

Hannes

[Bloompeak Support]

Hi @Max_Clark

Jira doesn't have a built-in solution for the report you mentioned. If you prefer using a marketplace app, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. To get a report of how many times the status of each issue is changed, you can have a look at Status Count And Entry Dates report. Entry date(see In Development, Ready for Testing, In Testing, In Development columns.) is status transition date and status count(see #In Development, #Ready for Testing, #In Testing, #In Development columns) is how many times an issue is entered to this status.

App Features:

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. 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.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

For further details, you can have a look at Status Time Reports How to Videos.

If you are looking for a completely  free solution, you can try the limited version Status Time Reports Free.

If you need any help, feel free to contact us via support@bloompeak.io or schedule a demo with us.

Hope it helps.

[Amay Purohit_RVS]

Hi @Max_Clark 

As an alternative, if you are fine with another mktplace app, you can try out 

Time in Status Reports 

One of the many reports the app has is the Issue Transition Count for a particular date range as shown below. 

More details here

Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Yuliia_Borivets__SaaSJet_]

Hi @Max_Clark 

• I think JQL, as the one suggested above, might be the best option for you if you are looking for specific transitions. Also, you can use the AI to help you suggest the query. Here is an example:

• If you want to check all status updates for all issues during a specific period, you can try Issue History for Jira from my team. Here, you can choose specific dates, projects, and fields you are interested in (statuses in your case) and create a custom report of changes:

You can also export the report to an Excel or CSV file to count the number of issues that have changed status. Let me know if you have any questions.