Show the time spent in a status on Dashboard report

[asha_somashekar]

Hi,

There is a report for all the tasks completed in the last 1 week. I want to add a column which shows the time spend to complete the task (updated date - start date).  Is there a way I can calculate and show this field instead of having to use external application.

Regards

Asha

[Trudy Claspill · Accepted solution]

Hello @asha_somashekar 

You could create a custom field to hold the information and then use the Automation for Jira feature to calculate the value and write it into that field.

[Valeriia_SaaSJet]

Hello @asha_somashekar 

This is an area where Jura is lacking to be honest. I can suggest you to try our add-on time-in-status-for-jira-cloud .

You can add a column that will show you time spend to complete the task. And also you will be able to generates 7 types of reports. So you can monitor the work duration in each status easily. 

Also, you can export a report as XLSX or CSV files for further analysis.

Hope my answer will be helpful for you

Best regards, Valeriia

[Hannes Obweger - JXL for Jira]

Hi @asha_somashekar

mind sharing a bit more detail about what you mean by start date - is that the time when an issue was created? 

Cheers,

Hannes

[asha_somashekar]

Yes Hannes by start date I mean the created or created date time

Regards

Asha

[Hannes Obweger - JXL for Jira]

Gottcha! If you're open to solutions from Atlassian Marketplace, I think you'd like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called “smart columns” that aren't natively available, including the time between created and resolved (along with many other time-related columns).

This is how it looks in action:

As you can see above, you can easily sort and filter by the time between created and resolved. You can also configure different display formats (like the number of days, or the number of hours), and use the column across JXL's many advanced features, such as support for issue hierarchies, issue grouping, sum ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Note that this all "just works", so there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Bloompeak Support]

Hi @asha_somashekar

The data you need is available in issue history and you can get it using the issue REST API. It provides the exact status change date time for each issue.

/rest/api/2/issue/{issueIdOrKey}?expand=changelog

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

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

Hope it helps.