How to Show the last Sprint in EXCEL ?

Question

Hello there !

I am using excel to import data from Jira and I don't how to import data from the last sprint. Note that i want to make a code in JQL that is fixed and will be updated every time I open the file, so I can't use fixed and Ad Hoc dates. Any Ideas ?

Daniel Turczanski - JQL Search Extensions · Answer

Hi @[deleted],

With standard JQL, you can only get a list of issues that belong to closed, open, or future sprints - regardless of the board they belong to.

You can also export the issues to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in previousSprint("ACME board")

Check out the documentation to see more examples.

I hope this helps!
Daniel

Andy Heinzer · Answer

Hi Ermis,

If I understand correctly, you are using something like the Excel of Jira addon which will automatically refresh issue data from Jira into Excel.  The way this works is to first create a JQL filter that can search for that issue data.  Unfortunately, there is no native JQL function in Jira to lookup issues by only the previously closed sprint.

I did come across a feature request I think is closely related over in https://jira.atlassian.com/browse/JRACLOUD-76634

There is the closedSpints() JQL function, however this cannot be isolated to a single sprint, but rather would return any issue in any closed sprint.

One way to workaround this could be to first save a filter that has a content such as

sprint = [sprintID or SprintName]

You could then setup your excel to always pull from that filter.  When it needs to be refreshed, you could go into Jira and update that filter to reflect the specific previous sprint.  I realize this is not an ideal solution, but it could at least prevent you from having to make this change manually in Excel even if you are making the change in Jira instead.