Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

What are some good queries to run to show velocity?

I know we have the velocity chart, but to see velocity related information surrounding a sprint, what are good queries I can run to show this?

1 answer

1 accepted

1 vote
Answer accepted

To measure velocity, I tend to use the created vs resolved JQLs. 

So I would do:

Created 

project = xyz and created >= start-of-daterange and created <= end-of-daterange 

Resolved

project = xyz and resolved >= start-of-daterange and resolved <= end-of-daterange 

Do you enter the date as like 12-02-2021?

The date format is actually yyyy-mm-dd so I'd do it like 2021-12-02. 

Another thing to note is that the dates always go to midnight, so you want your end dates to be the day after your actual end date so it goes until 11:59 pm your server time. 

So if I wanted to end on Dec 15 for example I'd do resolved <= 2021-12-16 instead.

Awesome thank you so much!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

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