Can I get reports based on the time tracking fields in tasks, stories, and epics?

[Brendan Gray]

I want access to more reports, specifically to any reports that can give me information or summaries using the time fields and not the story points. Is there a way I can get this?

[Zoryana Bohutska _SaaSJet_]

Hi @Brendan Gray  Under "time fields" do you mean data about logged time to issues?

[Emre Toptancı _OBSS_]

Hello @Brendan Gray

Jira's out-of-the-box functionality can keep estimates and work logs for each issue but the option to get cumulative reports is limited.

As a first option, you can try exporting this data to a CSV file and do some Excel magic on them. That is a manual solution but hey ... it is free.

The best-known app in the marketplace for managing and reporting work logs is TEMPO Timesheets (not our app). It can give you quite comprehensive reports about work logs. Man, those guys are good.

Some customers can't get their users to log work on issues or just need a different perspective so they get insight from issue workflows rather than work logged on issues. In case you are interested in that, our team at OBSS built Timepiece - Time in Status for Jira 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, Resolution Time, Cycle Time, or Lead Time. 

You can calculate averages and sums of those durations grouped by the issue fields or time segments (For example, see the total InProgress time per Epic or average Resolution Time per month). 

 

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 

Timepiece - Time in Status for Jira

EmreT

[Chris Boys]

Hi @Brendan Gray 

It looks like you now have lots of options above to consider for your reporting needs.

As an alternative to those mentioned, Umano.tech's Team Performance Summary reports on the agile practices of teams in sprint or kanban intervals.

Predefined agile success metrics enable greater team observability not just into HOW they're practicing, but also by surfacing the underlying drivers most impacting your team's effectiveness. Each interval reports on all tickets, whether estimated or not and whether the estimates are in time or points.

• Connecting Jira will unlock insights into your design & build practices and supporting metrics (profiling attributes such as speed, stability, completion rate, progress). Comments from Jira are also an input into your team engagement practices and supporting metrics (including things like your team's responsiveness and the balance of online communication across members within the project).

If you wanted a fuller view of your team's practices, you can add other tools to expand the insights.

• Connecting Bitbucket will unlock insights into your team's review practices and metrics, including review speed, time to merge (including approvers) and PR size.
• Connecting Slack or Mattermost will enhance the insights into your team's engagement metrics.

Our customers particularly value the ability to self-compare their current performance relative to their usual performance (rolling median for the last 6 intervals). As mentioned above, the underlying drivers provide context as to why a team may be above or below it's usual rate of performance.

Interval Reports can be exported as an email.

We run a 30 day free trial, and will populate your project space with 12 months of delivery data as default. Email me directly chris@umano.tech, or on chat @umano.tech if you have any questions and I'll do my best to see if we can help.

Go well,
Chris

[Ilze Leite-Apine - eazyBI]

Hi @Brendan Gray 

Indeed, Jira apps can be helpful. If you need in-depth data analysis, then you may check out eazyBI for the Jira app for custom reporting on Jira data.

There are some report examples that are based on time tracking to look at - from version to sprints, to user reports: Time tracking dashboard 

For instance, below are standard Sprint burn-down and velocity reports based on time tracking rather than on Story points (from the dashboard mentioned above):

As I see Jira Service Management labels to your questions, you may also be interested in reports related to service level metrics: SLA overview

Please do not hesitate to contact support@eazybi.com for any questions!

Ilze, eazyBI Customer Support Consultant

[Jakub Sławiński]

Hi @Brendan Gray 

you should check the Time Tracking category on the Atlassian marketplace:

https://marketplace.atlassian.com/categories/time-tracking

I am sure you will be able to find more reports, significant improvements and new features.

Part of the description of the Time Tracking category section:

Time tracking in Jira enables a number of different functions including automating invoicing and payment process for contractors or customers and providing visibility into resource allocation across teams, while removing the burden from your customer.

Time tracking use cases

Some popular use cases of time tracking tools for Jira include the ability to:

• Record time spent on each issue
• Create timesheets or invoices for clients and customers
• Generate visualizations on how teams spend their time
• Assign work in Jira as necessary based on real-time reporting
• Integrate with other planning and time tracking tools (such as excel, Google Drive, etc.)

[Mehmet A _Bloompeak_]

Hi @Brendan Gray ,

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

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.

[Shaili_RVS_Support]

Hi @Brendan Gray 

If you would be interested in a readymade solution, you can look at our plugin to get this data

Agile Tools : Epic Tree & Time in Status 

The app provides 5 important features, as below to track time and manage issue hierarchies

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

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

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

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

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