Hello!
I built a custom dashboard in Google Sheets to monitor sprint trends, sprint over sprint.
Every Friday, at the end of the sprint, I will pull sprint metrics using this JQL:
Functional Team[Dropdown]" = TeamA AND sprint in openSprints()
I then mold the data and insert it into a raw data tab.
However, the metrics I see from this do not match what I observe in Reports > Velocity. And other Jira dashboards.
Using JQL, is there a way to pull sprint metrics for a specific time and day? For example, I'm hoping to use a specific time and date to pull more accurate data on the following Monday of the sprint.
Something like:
"Functional Team[Dropdown]" = TeamA AND "Date[Date]" = "2022-03-14 11:30"
Also, I will be able to pull this at any time. Instead of specifically when the sprint ends and before the next one begins.
Thank you!
Hi @Peter Yoon
Unfortunately what you describe is not possible with out-of-the-box Jira features. Which I find quite disappointing as all of that information is in there...we just cannot get at it without:
Even something like Jira's interpretation of "velocity" can become altered if the underlying issues or sprint are changed after the sprint completed. (Which was probably not a good idea anyway...altering the source data.)
I suggest pausing to consider what you want to measure and what problem you are trying to solve with that information. There may be a way to get some of that information using JQL or automation rules to capture measures at a point in time. If not, you would need one of the other options I noted above.
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.