Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Time-tracking in JIRA

Good day.
We are currently using another task tracker, in which there is no time tracking functionality we need, which is why we are considering a parallel use of another tool with the possibility of a complete transition to it.
We need the following functionality:
We would like to set tasks for our developers, tasks can be on different projects and with a different set of tags.
We are interested in the possibility, at an arbitrary point in time, to get information about how much time was spent on tasks (total) marked with a specific tag or developers for a certain period of time.
An excellent solution would also be to track the time that the task was in a certain status (i.e. be able to change the status of the task, in work or in the queue).
Is there such an opportunity on this service?
If it is provided by the built-in tools of this service, could you please indicate how to use them?
Or can you give recommendations on how we can use this service to cover the described features, at least partially?

Thanks in advance for your reply.

7 answers

3 accepted

For a decent time tracking, you might take a look at Clockwork apps for Jira Cloud. 

They allow to automate time tracking and provide useful timesheet for reporting capabilities. 

There are also plenty of other time tracking tools in Marketplace so you will probably find something useful. 

I hope it helps. 

Cheers,
Jack

0 votes
Answer accepted
John Funk Community Leader Apr 21, 2020

Hi @d-vitaly  - Welcome to the Atlassian Community!

I recently went through that same adventure trying to find a tool. There is nothing built-in to Jira that will give you what you want. The closest thing we could come up with is MavenLink with an integration to Jira. 

Hi @d-vitaly 

You can check third party tools from Atlassian Marketplace

For example plugin Time in Status for Jira Cloud generate reports of how long issues stayed in the specific status and total time spend on issues. Also, this add-on calculates assignee time in each issue. It lets select issue list for your report by date ranges and project, filter, report, label, sprint or assignee (so you can view how long each user was in each status working on each issue)

Hope this information will be useful for you:)

WorklogPRO can help you with time tracking related reports, except time in status. For time in status, do you need the duration a task spent on each status? or do you need work entered when the task in different statuses? There are various apps for "Time in Status" but all of them measures the time issue stays on different statuses, not the work logged. 

Hello @d-vitaly 

Our team at OBSS built Time in Status app for this exact need.

You didn't indicate your Jira platform but Time in Status by OBSS is available for Jira Server, Data Center and Cloud.

Using Time in Status you can:

  • Report on how much time each issue spent on each status, on each assignee or on each user group.
  • Get charts on these durations.
  • Use JQL to select the issues to be used for reporting so it is possible to get issues from multiple projects or filter them based on a label. Any valid JQL can be used.
  • Get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can solve this using Time in Status by OBSS.)
  • Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
  • Export your data as XLS, XLSX or CSV.
  • Access data via REST API.

The reports are calculated using Jira issue histories so when you install the app, you will be able to get reports on your existing issues as well.

Below is the link to the documentation for Cloud edition of Time in Status which contains screenshots and details about usage:

https://dev.obss.com.tr/confluence/display/MD/Time+in+Status+Cloud

For further questions, you can reach us through pluginsupport.obss.com.tr

Emre TOPTANCI

@Emre Toptancı _OBSS_I have a question that I hope you can answer quickly. does your product aggregate the time spent in a status if the status changes "in and out" of a value? for example, let's say we have statuses OPEN, IN DEVELOPMENT, PAUSED, QA. if the issue status is IN DEVELOPMENT for 3 hours, then PAUSED for 3 hours, then back to IN DEVELOPMENT for 3 more hours then QA. will the total time show 6 hours IN DEVELOPMENT?

Hello @Daniel Hurtubise ,

Yes, the report will show the total time spent in each status.

EmreT

Hey @d-vitaly 

> We are interested in the possibility, at an arbitrary point in time, to get information about how much time was spent on tasks (total) marked with a specific tag or developers for a certain period of time.

That is possible to do with Everhour + Jira integration. You can create custom reports grouped by task or member or project and exclude / include specific information, such as tags. Something like that.

reports-sprint-progress-screen@2x.jpg

> An excellent solution would also be to track the time that the task was in a certain status (i.e. be able to change the status of the task, in work or in the queue).

Unfortunately, we don't track history of changes on our side. Our reports always shows you most recent information. So, as soon as you change something on Jira side, we will synchronize that back.

I have a free tool that I think will give you what you need. It's called the Enhanced Jira Query Tool. It is a Google Sheets application that leverages the Jira REST API to retrieve data from Jira. It can retrieve any field and its respective properties from Jira. It also has special derived fields not available in Jira such as time in status, cycle/lead time, working time, waiting time, and unplanned work to name a few. You can find the tool along with other free tools I have created on the Agile Creatives Tools page. There is a demo video and usage guide for all the tools. I have also created a training video on Udemy for the Enhanced Jira Query Tool.  Here is a coupon that will allow you to enroll in the course for free for the next 3 days. I hope this helps you both. Please let me know if you have any questions.

Cheers!

Mike

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

4,574 views 12 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you