Filter needed for time created to time resolved

[ckopanon]

Looking to create a filter that would show all work items that were resolved within 24 hours of being created. Is this possible with JQL?

[Rahul_RVS]

Hi @ckopanon 

If you are fine to try out a mktplace app for this need, pls do take a look at

Time in Status Reports 

The "Time between status Transitions" report can meet your requirement. You can easily filter your issues calculating the time between 2 specific statuses in the issue workflow which will help you track the time from created to resolved state. Also the app has 20+ reports to meet a variety of use cases.

More details here.

Disclaimer : I am part of the app team for this add-on

[Birkan Yildiz _OBSS_]

Hey @ckopanon 

That's a great question. It's a very common reporting need, but unfortunately, native JQL can't perform calculations between two date fields like created and resolved.

This is a classic scenario where a Marketplace app with advanced reporting is the most direct solution.

Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira, and it's designed to give you this exact data.

Instead of a JQL function, you would use our Duration Between Statuses report. You can configure it to calculate the exact time from issue creation to resolution for every item in your filter.

The report can then be easily sorted or filtered to show you the precise list of all work items that were resolved within 24 hours.

A key benefit is that our reports can use custom business calendars, so you can get a list of issues resolved within "8 business hours," for example, which excludes nights and weekends for more accurate SLA tracking.

You can check Timepiece on the Atlassian Marketplace. Hope this helps you get the list of issues you need!

[Natalia_Kovalchuk_SaaSJet_]

Hi @ckopanon !

It isn't possible to do this directly with JQL, as it doesn't support calculations between two date fields, such as created and resolved.

However, you can try these workarounds:

• Created vs Resolved Chart -  shows the number of tasks created and resolved during the specified time period in a project.

• Issue History for Jira from SaaSJet - allows you to see when each work item was created and resolved. 

Using this app, you can filter work items by project, updater, and date range. In the Columns' menu, choose the fields Created and Resolved. You'll get such a report. 

Using the Advanced export option in the app, you can generate the Field changes duration report, which shows how much time was spent between task creation and resolution. For example: 

Also, you might find this article useful: 👉 Jira Issue Tracking Made Simple: Measure Team Progress per Week

[Trudy Claspill]

Hello @ckopanon 

That is not possible with only the native Jira JQL capabilities because it doesn't support comparing one issue field to another within the JQL.

Without an app what you can do as a work around is use an automation rule to calculate the difference between the Resolved and Created timestamps and store that information in another field. Then create your JQL to filter on that field.

[Ivan Manolov - JXL]

Hi @ckopanon

This is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their reporting needs. 

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a long list of so-called smart columns and history columns that aren’t natively available, including e.g. time between created and resolved (i.e, time to resolution).

This is how it looks in action:

As you can see above, you can easily sort and filter by your smart and history columns; you can 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.
This all doesn't require any SLAs to be set up, and works for issues of any project type.

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,

Ivan

[Iryna Komarnitska_SaaSJet_]

Hi @ckopanon ,
If you don't mind using apps from the marketplace, I can recommend using an app from my team called Time in Status.

Generate a Time in Status report, and add the Created and Resolved columns. You will be able to view the dates and duration for each status. And with the help of the created status groups, you can calculate various time metrics.

The Status Entrance Date report allows you to view the dates and times when tasks transitioned to different statuses.

I hope you find this helpful.