It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Repsonse time calculation defect

I am trying to pull report with "Projecct Nam", "Created Dated", "Date first response". So when i put ......within the last 5 minutes then it shows 0 result i tried till 1 hour still zero. In general there is 100 tickets. 

So is it querying all first time resolution in last 5 mins from current time withing the specific prject and date define ?

Isn't that the query should be straight forward of within 5 mins of any ticket created within the date range.

I am looking for all tickets which took more than 10 for first time response or before 10 mins within specific date.

image.png

 

1 answer

1 vote

Hello @Ranjith Parmel

Welcome to the Atlassian Community!

Jira does not have a system field called "Date first response", so I believe this is a date picker or date/time picker custom field you created to have the date where the first answer was added to the issue. Is that correct?

Additionally, I suppose that the "Created Dated" field is the system field "created" which is automatically filled with the issue creation date and time. Is that correct?

If that's the case, the JQL selected will consider the exact value added to the issue field and run it against the filter selected. Additionally, this time filter (within the last/More than) works in a different way for Date/time picker and Date picker fields.

Let me give you a practical example to better explain it:

  1. Let's suppose you created an issue (issue A) 10 minutes ago and updated the "Date first response" with the current date (2020-07-31)
  2. The "Created" field Is a Date/time picker, however, the "Date first response" is a Date picker
  3. Then, you configured your JQL query to return issues created with the last 15 minutes, with the "Date first response" within the last 5 minutes

The results of the query above will return the issue A, because the issue was created within the last 15 minutes (10 minutes ago) and the "Date first response" is a date picker field, so it will consider the current date select based on the time configured (Within the last 5 minutes, would consider the current date).

Let us know if this information helps.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Desk

The Complete Guide to Atlassian for ITSM

Hi Atlassian Community! This is Teresa from the Atlassian team. My colleague Paul Buffington @Buff and I are excited to share a brand new ITSM resource we’ve created – "The Complete Guide to At...

1,105 views 7 16
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you