How do I pull sprint metrics for a specific time and day using JQL?

[Peter Yoon]

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!

[Bill Sheboy]

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:

• purchasing a marketplace addon app, or
• running the REST API or webhooks repeatedly to pull out the data for analysis in another tool external to Jira

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