Hi I dont want to include weekends to Calculate any TAT of an issue

[Vipin Kumar]

Please help me out with the JQL query.

[Valeriia_Havrylenko_SaaSJet]

Hi @Vipin Kumar 👋
Welcome to the Atlassian Community!

You might have to create your own solution or use a third-party app to access this data. So if you consider installing third-party add-ons to help, you can try Time in Status developed by my team.

The algorithm for excluding weekends when calculating the TAT for an issue is quite simple.

First, you must set up your work calendar - add days off, breaks, holidays, etc.

In the generated report, select the required project. To generate a report, select the Created by a specific date range filter—select a date three days before the current one. You can also specify the time period you need.

In the report, select the Business Days data format. This will prevent the calculation from considering non-business hours.

Remember that you can always contact us at Support to get answers to all your questions.

I hope this is useful for you!

[Rahul_RVS]

Hi @Vipin Kumar 

Welcome to the community !!

Not sure it can be achieved through native Jira. You may need to write your custom solution or use a 3rd party app to get this data. If you are open to try one, pls do take a look at 

Time in Status Reports 

With this app you generate time in status for multiple issues with multiple filter and grouping options. You can group your statuses to define your TAT/resolutions times. Also the calendar feature allows to remove weekends and non working hours from the calculations.

Also the app has 20+ reports to meet a variety of time in status use cases. Do give it a try.

Disclaimer : I work for the vendor who built this app

[Gizem Gökçe _OBSS_]

Hello @Vipin Kumar ,

Welcome to the community!

There is no built in solution in Jira for this. So in order to track TAT without including weekends (or non-working days) I suggest you use a marketplace app.

Timepiece - Time in Status for Jira ,the oldest and leading "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need.  Our app is available for both Jira Cloud, and Data Center. 

Timepiece mainly allows you to see how much time each issue spent on each status or each assignee. You can combine the time for multiple statuses to get metrics like TAT (Turn Around Time.), Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

 

The application also offers custom calendar support. Calendars can be configured based on your working hours, excluding holidays and non-working hours (even lunch breaks) from the calculation. Timepiece reports can be generated based on your custom calendars. In your case, you can set up two different calendars for each of your shifts. By selecting the appropriate calendar, you can retrieve all the reports you need from the application and easily analyze performance between shifts.

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.

Visit Timepiece - Time in Status for Jira to explore and enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Bill Sheboy]

Hi @Vipin Kumar -- Welcome to the Atlassian Community!

The built-in JQL features do not support excluding weekends with the date / time functions and features: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

Please describe the problem you are trying to solve and what you mean by "TAT".  Knowing that may help the community to offer alternatives.

Kind regards,
Bill

[Vipin Kumar]

TAT means- Turn Around Time. The amount of time it takes to complete a task.

[Vipin Kumar]

I want to calculate duration from X days to Y days excluding weekends. Please help me out with JQL query

[Bill Sheboy]

You seem to want to calculate the Lead Time (from created to completed) or some form of cycle time (such as Build Cycle Time, from start of work to completed).

As already described, the built-in JQL cannot calculate the difference and cannot exclude the weekend days (for more than a single specific week).  You would need one of the workarounds described by others:

• export the data and perform the calculation with other tools
• use a marketplace addon / app
• use an automation rule and custom fields to perform the calculation and store it for use with basic JQL queries

[Hannes Obweger - JXL for Jira]

Hi @Vipin Kumar

As you can see from the previous answers, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their reporting needs. 

If a Marketplace app is an option for you, I think you'll 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 history columns that aren’t natively available, including an issue's time between created and resolved, time in [status], or time between [status] and [status].

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to XSLX (Excel, Google Sheets) or CSV in just two clicks. 

Any questions just let me know,

Best,

Hannes

[Mehmet A _Bloompeak_]

Hi @Vipin Kumar

Welcome to the Atlassian Community!

If you prefer using a marketplace app, 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.

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 get TAT of an issue by using lead time(the time interval between the moment an issue is requested to the moment it is completed) report. Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Lead Time for Each Issue report.

For further details, you can have a look at Cycle Time and Lead Time in Jira: Productivity Measurement with Two Critical Parameters article and Status Time Reports How to Videos.

App Features:

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

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

[Danut M _StonikByte_]

Hi @Vipin Kumar,

I assume that by TAT you mean Turn Around Time (TAT): The amount of time it takes to complete a task or process. I think is the same as Lead Time (or maybe Cycle Time). 

If so, be aware that this type of metric cannot be measured by simply using an JQL. You will need a report or gadget that is able to calculate this.

You could try using the Control Chart report of Jira. It has an option for excluding non-working days, but unfortunately it only shows a chart not a report with the individual issues. 

For something better and more detailed, you could search for an app on Atlassian Marketplace. 

If you are open to using an app from Marketplace, be aware that our Great Gadgets app includes some gadgets that allow you to measure TAT: Control Chart gadget, Cycle Time Trend gadget and Histogram Chart gadget.

All these gadgets have an option to exclude the weekends.

Here are some example for measuring and showing TAT by using these gadgets:

Cycle Time Trend Gadget

Cycle Time Trend Gadget 

Histogram Chart

These gadgets can show a Data tab with TAT for each issue. This report can be exported in CSV format.

 

Danut.