Ho to generate a progressive bar diagram/chart

[Vamsi Fragale]

Is there a way to show progress of a story over time?
So, say you have 1000 stories and you want to see how many moved from Backlog to in-progress, or any other status on a weekly basis. Basically monitor progress ..is this possible?
I hope exporting the data to excel week after week to create a graph is not the only way!

[Valeriia_Havrylenko_SaaSJet]

Hi @Vamsi Fragale  👋

Welcome to the community! 

For this i recommend you to try Time in Status for Jira. In Sprint Report feature in add-on you can get information from "Committed" and "Completed" sections that work items or issues the team has committed to and completed in the specific sprint.

Also you can get this info by Status Count report or Transition Count report

The Status Count report shows how many times an issue has been in each status.

Chart view of report:

The Transition Count report shows how many times an issue has moved between all statuses in the workflow.

Chart view of report:


Add-on has a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

Hope it helps 😌

[Mehmet A _Bloompeak_]

Hi @Vamsi Fragale

Welcome to the Atlassian Community!

If you prefer to use 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. For your case, you can have a look at Time in Status for Each Issue, Status Count And Entry Dates, Lead Time for Each Issue, Cycle Time for Each Issue reports. You can filter by Issue Type, Status, Assignee, Created fields or by typing your own JQL(using "Switch to JQL" button).

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

• 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.

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

Hope it helps.

[Amay Purohit_RVS]

Hi @Vamsi Fragale 

Welcome to the community !!

If you are open to try out a mktplace solution, to get this data you can have a look at our app.

Time in Status Reports 

One of the many reports which the app provides is Status count and status transition reports which will help meet your use case.

The app is free upto 10 users

Disclaimer : I work for the vendor who built this app

[Gizem Gökçe _OBSS_]

Hello @Vamsi Fragale ,

Welcome to the Atlassian Community!

Jira does not provide this functionality out-of-the-box. However, the required data is available in each issue's history but you will need to use a marketplace app to get ready-to-go reports.

For this, I would like to introduce you to a very advanced tool with which you can easily access the reports you request. I can recommend Timepiece - Time in Status for Jira which is built by my team at OBSS. It is available for both  Jira Cloud, and Data Center.  

Time in Status mainly has several types of time reports (showing how much time each issue spent on each status, assignee, or group) but the app also has Status Count and Transition Count reports. These reports show how many times each status and each transition was used by each issue.

For all numeric report types, you can calculate averages and sums of those values grouped by the issue fields you select. Grouping by parts of dates (year, month, week, day, hour) or sprints is particularly useful here, as it allows you to compare different time periods or see the trend. Since you want to see your reports on a weekly basis, I think you will find this feature very useful. Please take a look at the screenshot below and see if this type of report is useful for you. (Transition Count Report grouped by creation week)

Timepiece app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It supports both Company Managed and Team Managed projects for Jira Cloud.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

Visit Timepiece - Time in Status for Jira to explore how our JIRA add-on can revolutionize your metrics measurement process. Enjoy a 30-day free trial to experience the full range of features. 

Hope it helps,

Gizem

[Vamsi Fragale]

Thank you, Gizem.
May I know what is the cost of this tool after the trial period?

[Gizem Gökçe _OBSS_]

You're welcome! 

Actually the pricing depends on how many active users you have in your JIRA environment.

You can easily calculate the cost of the app from the link above by entering the number of active users in your JIRA.

Timepiece - Time in Status for Jira 

Please note that Time in Status uses the standard cloud licensing model, created by Atlassian. According to this model, the number of app licenses MUST match the number of active users on your Jira.

If you have more questions regarding our app, you can always contact me by emailing plugin@obss.com.tr 

I hope you benefit from Timepiece - Time in Status for Jira 

[Danut M _StonikByte_]

Hi @Vamsi Fragale,

This can be easily done by using the Cumulative Flow Diagram (CFD) gadget offered by our Great Gadgets app. 

The gadget can be configured to group data by 1-week interval as you want. The chart can be generated not only by count of issues, but also by story points or by other estimation types. All you have to do is to configure the gadget to use  a filter / JQL that returns your user stories and configure it to generate bands by issue statuses.  

Read more about this gadget and its use cases in this article from our blog: How to track multi-team or scaled-agile projects (such as SAFe®) in Jira with Great Gadgets app  

I hope this helps. If you need any questions, please contact support@stonikbyte.com.

Disclaimer: I am part of the team developing these gadgets.

Danut

[Mary from Planyway]

Hi @Vamsi Fragale 
It's Mary from Planyway 

Here are some methods you can use:

1. Jira Dashboards: Jira's dashboards are highly customizable and allow you to create a variety of gadgets that can track progress. You can use gadgets like the 'Sprint Burndown Chart', 'Cumulative Flow Diagram', 'Control Chart', or 'Two-Dimensional Filter Statistics' to see how many stories moved from one status to another.

2. Burn-down/Burn-up Charts: These charts are available in Jira's Agile Boards (Scrum or Kanban). They provide a graphical representation of work completed over time versus the total scope. This can be a good way to track the progress of stories within a sprint or over a period.

3. Reports in Agile Boards: Jira's Agile Boards offer a range of reports like Sprint Reports, Velocity Charts, Epic Burndown, etc., which help track the progress of stories over time.

4. Custom Filters and JQL (Jira Query Language): You can create custom filters using JQL to track the movement of stories from one status to another. These filters can then be used in dashboards to create meaningful graphs or reports.

5. Automation Rules: Jira's automation engine can be used to create rules that log changes in story status. These logs can then be used for analysis.

6. Jira’s REST API: For more advanced needs, you can use Jira’s REST API to extract data and create custom reports or integrate with other tools for reporting purposes.

7. Add-ons and Marketplace Tools: Jira's marketplace offers numerous add-ons like 'EazyBI Reports and Charts for Jira' and 'Rich Filters for Jira Dashboards' which provide advanced reporting capabilities.

[Trudy Claspill]

Hello @Vamsi Fragale 

Welcome to the Atlassian community.

I think the closest native match for what you describe is the Cumulative Flow Diagram.

https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-cumulative-flow-diagram/

There is also the Created vs. Resolved chart. That however reports only on issue Created and issues where the Resolution field has been set (usually associated with transition to a "done" status).

https://support.atlassian.com/jira-cloud-administration/docs/use-dashboard-gadgets/

Jira doesn't otherwise natively have a report that will show you how many issues transitioned to a status each week over a time period of multiple weeks. Getting such a report would required the use of a third party app.