I have tried to automate time tracking field using the automation rules - Rule - 1 (Create a timestamp when issue transitioned from "To-Do" to "In-Progress") JQL : {{#now}}toMinutes{{/}} Rule - 2 (Update time tracking field based on the time spent between status field transition from "In-Progress" to "Done") JQL : { "update": { "worklog" : [ { "add": { "timeSpent" : "{{#=}}{{#now}}toMinutes{{/}} - {{issue.properties.timestamp_in_progress}}{{/}}m" } } ] } } After applying this rule i get time tracking logged in the issue successfully. But it was logged on behalf of "Automation by JIRA" Question : How can i achieve this automation through any customer "people" fields which i have named "Developer" ? (i,e whom so ever is assigned in the developer's field, the work log must be added on behalf of that developer, not automation in JIRA)

Hi @Hemant Garg As an alternative, 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. * 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, 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 free solution, you can try the limited version Status Time Free. Hope it helps.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to automate time tracking field on behalf of developer assigned ?

Hemant Garg_3saq8k

I have tried to automate time tracking field using the automation rules -

Rule - 1 (Create a timestamp when issue transitioned from "To-Do" to "In-Progress")

JQL : {{#now}}toMinutes{{/}}

Screenshot 2023-01-11 at 10.03.36 AM.png

Rule - 2 (Update time tracking field based on the time spent between status field transition from "In-Progress" to "Done")

JQL :

{
"update": {
"worklog" : [
{
"add": {
"timeSpent" : "{{#=}}{{#now}}toMinutes{{/}} - {{issue.properties.timestamp_in_progress}}{{/}}m"
}
}
]
}
}

Screenshot 2023-01-11 at 10.08.05 AM.png

After applying this rule i get time tracking logged in the issue successfully. But it was logged on behalf of "Automation by JIRA"

Screenshot 2023-01-11 at 10.11.39 AM.png

Question : How can i achieve this automation through any customer "people" fields which i have named "Developer" ?

(i,e whom so ever is assigned in the developer's field, the work log must be added on behalf of that developer, not automation in JIRA)

Accepted answers

All comments

Shahbaz Sharif_obr2ci

Best Aproach Use Status Time Free Work Extremely fine for me I strongly recommend "Status Time Free" App

Adaeze_Jude_HEROCODERS

Hi @Hemant Garg

I would suggest that you try out Clockwork Automated time tracking & timesheets free.

Clockwork provides you with the ability to track time both automatically and manually using a form.

You can log work automatically, that is when the user set the status of an issue to an active status, time is calculated for the period for which the issue is "in progress" or active status.

Emre Toptancı [OBSS]

Hello @Hemant Garg ,

I strongly suggest you not try to automate this. The timesheet data MUST be entered manually.

I've seen many many customers trying to automate this and all those attempts either failed to build an automation or the resulting data was not trustworthy so they didn't use it. When you try to automate this, it is really hard to prevent overlaps between issues and hard to make sure that your people always transition issues on time.

Don't get me wrong. I am not suggesting you to not use timesheet data. On the contrary, timesheet data is very valuable, but it must be entered manually by users.

Having said these, if you still want to get something from issue transitions, you can do the same with a marketplace app. Our team at OBSS built Timepiece - Time in Status for Jira for this exact need. It is available for Jira Server, Cloud, and Data Center.

Time in Status mainly allows you to see how much time each issue spent on each status and on each assignee. This way, you can see how much time each issue spent on statuses that represent work. You just need to make sure that issue statuses are updated on time.

tisCloud_StatusDuration_LeadTime_with Estimates.png

The app has Consolidated Columns feature. This feature allows you to combine the duration for multiple statuses into a single column and exclude unwanted ones. It is the most flexible way to get any measurement you might want. Measurements like Issue Age, Cycle Time, Lead Time, Resolution Time etc.

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer (organization) or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend.

tisCloud_StatusDuration_LeadTime_Average_TimeGrouped.png

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. It supports both Company Managed and Team Managed projects.

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.

And the app has a REST API so you can get the reports from Jira UI or via REST.

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

Karolina Wons_SaaSJet

Hello @Hemant Garg

As it's mentioned above, the best way to monitor the time spent is to use some third-party add-ons.

If you're ok with using it, I can recommend you try Time in Status for Jira Cloud which generates 7 types of status time reports.

All you need is to choose the necessary report (Time in Status, Assignee time, Status Entrance Date, Average time in status, etc) and set date ranges.

GIF TIS.gif

Also, you can track time spent in status directly on the issue card layout and export data CSV or XLSX files.

You can try a 30-day free trial version to ensure how helpful is it in your case.

This add-o is developed by my SaaSJet team. Please let me know if you have any questions.

Hemant Garg_3saq8k

Totally agreed, this app is very useful.

Hemant Garg_3saq8k

I checked this app and it give a lot more insights than expected. Very useful

Hemant Garg_3saq8k

thanks mate. was looking for something like that.

Madhu_RVS

Hi @Hemant Garg

You can try out our plugin,

Time in Status Reports

The add-on provides the time in each status for the entire lifecycle of the issue.

Also multiple reports are available to track issue time with Assignee.

You can group multiple statuses and only include the ones you need to define a total combined time in those statuses.

Do try it out.

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

Karolina Wons_SaaSJet

@Hemant Garg thank you for your response!

Mehmet A _Bloompeak_

Hi @Hemant Garg

As an alternative, 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.

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, 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 free solution, you can try the limited version Status Time Free.

Hope it helps.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud