JQL Query - Between two date range

[Erhan Karakoc]

I'm looking to find incident resolve how long does it take between created and resolved dates.

What i need exactly; "Resolved incidents more then 3 days after created in the past year."

[Zane eazyBI Support]

Hi @Erhan Karakoc

You may consider using "eazyBI for Jira" app to analyze issue lead and cycle time. The tool offers a wide set of metrics, like count of created, resolved, and open issues, time in transition statuses, spent hours, and others. Those metrics could be analyzed across Time, and you can run reports for specific or relative periods, like the last 12 months, previous month, or current year.

For example, you may build a report to filter issues resolved in the selected period and group them by the time it took to resolve them. Report readers may interact with the chart to see issues behind the numbers (see picture below).

And here is the report example you can interact with: https://eazybi.com/accounts/1000/cubes/Issues/reports/50399-issue-resolution-intervals-lead-time

You are welcome to check out more report templates in eazyBI Demo account at any time (no login require):
https://eazybi.com/accounts/1000/dashboards/7513-age-lead-and-cycle-time

Best,
Zane / support@eazyBI.com

[Gökçe Gürsel {Appfire}]

Hi @Erhan Karakoc ,

You can use Enhancer Plugin for Jira's Time between custom fields for this use case.

The Time Between Custom Field calculates the amount of time passed between two statuses/events. It can be configured to work against a specific working calendar as well as excluding paused statuses.

You can search issues against this custom field in the issue navigator.

Enhancer Plugin for Jira also has many advanced features such as workflow enhancements, handy gadgets and a versatile list of custom fields.

Please let me know if you have further questions.

Hope this helps.

Cheers,

Gökçe

[Rahul_RVS_Support]

Hi @Erhan Karakoc 

Welcome to the community !!

If you are fine with a third party app, for a complete solution to track time spent on each issue or time between statuses or time spent by resources, you can try out our add-on. Also you can create dashboard gadgets for each report type.

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The add-on provides the time in each status for the entire lifecycle of the issue and you can filter by issue type as well. You can also combine your statuses to define your lead/cycle/resolution time and also extract the transitions history of the issues. The main features of the app are as below

Also there is a report for the dates when issue transitioned from one status to another.

• Multiple Time in Status Reports. Excel Export available for all status reports.
  
  • Time in Status
  • Time with Assignee
  • Time in Status with Assignee
  • Time with Assignee per Status
  • Status/Assignee Count
  • Multiple Transition Reports
  • Avg Time in status reports
  • Status Change Dates Report
  • Time in Status Per Time Grain
  • Time with Assignee Per Time Grain
• Status grouping
• Save your reports
• CSV Export
• Multiple chart types
• Dashboard Gadget

Disclaimer: I work for RVS, the vendor for this app, and I am one of the developers of the app.

[Emre Toptancı [OBSS]]

Hello @Erhan Karakoc ,

Our Team at OBSS built Time in Status that might help you. It is available for Jira Server, Cloud, and Data Center. 

Time in Status basically allows you to see how much time each issue spent on each status and on each assignee. 

   

The app has Consolidated Columns feature which will get you measurements like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 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. 

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 week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) is particularly useful here since it allows you to compare different time periods or see the trend.

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. 

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.

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

https://marketplace.atlassian.com/apps/1211756/

EmreT

[Bloompeak Support]

Merhaba @Erhan Karakoc,

Welcome to the Community!

You are looking for "how long it takes for an incident(issue) from creation to resolution" and this refers to "lead time". You can have a look at the article below that includes details on how to get various lead time reports. Hope it helps.

Cycle Time and Lead Time: Productivity Measurement with Two Critical Parameters

[Tansu Akdeniz]

Hi @Erhan Karakoc 

Welcome to the community.

Do you need duration or the issues which stayed unresolved more than 3 days?

If you have Jira service management, it is better to define SLA metric for new issues. You can report breached issues, average duration etc.

If you have Script Runner add-on, please use this query.

• type = Incident and issueFunction in dateCompare("", "created +3d < resolutionDate ") and created > "2021-01-01" and created < "2022-01-01"

Related doc.

[Pramodh M]

@Erhan Karakoc 

Welcome to the Community!!

Dynamic resolving of dates is not possible in JQL.

We would need to use JQL Tricks plugin or script runner in order to get the data for this requirement!!