How do I get a report to show me time tracking of an Epic in a Kanban board.

[Liesl Jordaan]

Good day

I am trying to manage research & development projects for hardware and firmware of telemetric projects. This is very much a pull mechanism where an Epic is representative of an outcome required. Stories with sub-tasks are created in the epic of which phases are represented by labels. All of this takes place on a Kanban board

I understand Kanban has a lovely report for Time tracking that Shows the original and current time estimates for issues in the current project. This can help you determine whether work is on track for those issues. 

I am looking for something similar, but I don't want to order by incomplete of completed issues I would like it grouped by Epic - by label, linked Stories - with linked sub-tasks and Tasks if possible. Is there a way I can do that? Please be assured I am a novice in Jira and your help and guidance will be appreciated.

What I am trying to understand is the throughput for an epic as well as the phases that are indicated by my labels. I want to also understand how much time something is being blocked because we are waiting for something.

[Zoryana Bohutska _SaaSJet_ · Accepted solution]

Hi @Liesl Jordaan 

To understand how much time something is being blocked you can also try Time in Status for Jira Cloud.

It allows getting time in status for each issue type, including epic. You can read more and view the video on how to do it here.

Please pay attention that this app is developed by my SaaSJet team.

Regards

[Bill Sheboy · Accepted solution]

Hi @Liesl Jordaan  -- Welcome to the Atlassian Community!

The short answer is: you may need to investigate custom reporting options for purchase from the marketplace: https://marketplace.atlassian.com/search?hosting=cloud

Longer answer:

• Regarding time tracking, the built-in report has just a few options.  You may want to search this community forum specifically for time tracking to see if others have found work-arounds for what you ask.
• And, as you are using labels to reflect steps in your process (phases), Jira reporting may not help.  The built-in reports assume use of Status for steps, and support measurement based on that.  For example, you could answer some of your questions with Atlassian's interpretation of a control chart, and here is the documentation for that: https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-control-chart/
• Regarding "throughput", do you mean number of epics completed over time?  If so, you could see that with Atlassian's interpretation of a cumulative flow diagram (CFD).  The documentation for that one is here: https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-cumulative-flow-diagram/  Also consider checking into the marketplace for dashboard gadgets which have better reporting for teams using Kanban methods.

Best regards,
Bill

[Antuan Sammak _ FusionTech Innovations]

Hello @Liesl Jordaan ,

You might want to give a try our new application  it offers a new approach of reporting that shall help your organization and teams to analyze teams performance and identify potential improvements.

Also please feel free to raise any feature change or new app concept that you think it will be useful to have it through our Portal and we would be happy to work on it.

Thank you in advance for considering our solutions.

FusionTech Innovations

[Bloompeak Support]

Hi @Liesl Jordaan ,

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status.

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.

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

[Rhys Diab _Agile Docs_]

Hi @Liesl Jordaan 

I understand your first choice was to be able to do this without an additional app, but just letting you know if you decide to go in that direction, we put together an app called Agile Docs which can do this.

Are the labels for phases attached to the Epic or the Story level?

If they're attached to the Epic, you could create a filter for Epics of a certain label and bring that up in Agile Docs.

Agile Docs will show you a time tracking report for the label (top level), Epic, Story and Sub-task levels.

 

Let me know if this is what you're looking for.

Best Regards,

Rhys

[Emre Toptancı _OBSS_]

Hello @Liesl Jordaan

I think I got the perfect thing for you, our team at OBSS built Time in Status app for this need. It is available for Jira Server, Cloud, and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee. You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time, or Lead Time. 

You can calculate averages and sums of those durations grouped by issue fields you select. 

For example, using the Status Duration report of TiS, you can get the sum of status times grouped by Epic, or grouped by Epic and Labels at the same time. Here is a use case article that explains how to get sums per Epic:

https://dev.obss.com.tr/confluence/pages/viewpage.action?pageId=323363346

You can also measure block times using the Any Field Duration report of TiS. Below is a use case article that explains how:

https://dev.obss.com.tr/confluence/pages/viewpage.action?pageId=303792739

  

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

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.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
• Export your data as XLS, XLSX, or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets

https://marketplace.atlassian.com/1211756

EmreT

[Liesl Jordaan]

Apologies for not responding sooner, I had some unfortunate events. I will investigate your proposal, I was hoping for a way that I could do this without an additional app if possible.

[Rahul_RVS_Support]

Hi @Liesl Jordaan 

If you would be interested in a ready made solution, you can also try out our plugin, The app provides 5 important features, for roll ups of time estimates and story points for your Epics, along with time tracking of issues and users. I believe it covers all your requirements of Epic tracking and Links Hierarchy

Agile Tools : Epic Tree & Time in Status 

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

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

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

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

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

Thanks

Rahul

[Liesl Jordaan]

Apologies for not responding sooner, I had some unfortunate events. I will investigate your proposal, I was hoping for a way that I could do this without additional app if possible.