Create Sprint Report in Structure

[larry joseph]

I would like to create something like the Sprint Report https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-sprint-report/ using structure.  I can see how to pull in the issues, and group by each sprint they were in.  But I do not see a way to get their status as of the time the prior sprints closed.

Ex: -- yes I know a story shouldn't take 3 sprint ;-)

Sprint 1 - Story A is In Progress

Sprint 2 - Story A is in Testing

Sprint 3 - Story A is Closed

I want to group by sprint and see Story A in each sprint group with it's Status as of the time of that sprint.  Jira has this data somewhere since it is able to recreate the as of view for the Sprint Report.  Is this possible to do this in Structure?  Thanks

[larry joseph]

Little more googling and this seems to be working,  Suggestions welcome...

with thesprint = if issuetype : parent{summary} :

with end = sprint.filter($.name = thesprint).enddate :

historical_value(this, "status", end)