How can I show only the last assigned sprint value in a structure?

[Fatih Sahin]

Hi Community,

As a Scrum Master, I am using a team structure to check if all the stories underneath a feature is planned in the upcoming sprints. I use a sprint column for that but it shows all previously assigned sprints in that field which makes the field filled in with a lot of values and hard to check the latest one. Is there any way that I can show only the latest greatest assigned sprint value of the story? 

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Fatih Sahin 

You can show only the last assigned sprint in the Formula column with this formula:
sprint.last()

It is possible to apply additional filtering conditions if needed. For example, to exclude Closed Sprints completely and show the last Active/Future assigned Sprint like this:
sprint.filter($.state != "closed").last()

I hope this helps. If you need further assistance with this or help with anything else, please reach out to us directly at our portal: https://tempo-io.atlassian.net/servicedesk/customer/portal/6/group/1051

Best regards,
Stepan Kholodov
Tempo

[Fatih Sahin]

Hi Stepan,

You can not predict how much happy you made me with that answer. It works very well! My suffer is fully healed! Thanks a lot for your help! I am too appreciated! :)

[Fatih Sahin]

@Stepan Kholodov _Tempo_  is there a way also to sort the items in ascending order based on that custom column I created with that formula? I made a new column with the formula you shared and named it as "Last Sprint". Can I order all the rows based on that "Last Sprint" values? I could not find an option to do that. Can it be done by coding maybe?

[Stepan Kholodov _Tempo_]

@Fatih Sahin 
Sure, you can do it by simply clicking on the Formula column's name(clicking on it again will reverse the sorting order). But in this case, the formula should be like this: sprint.name.last() for achieving the right sorting. 

Also, if you have any generators in the structure, the Automation button should be clicked on to hide the list of the generators at the top of the structure(this enables the sorting by columns).

Best regards,
Stepan Kholodov
Tempo

[Fatih Sahin]

Thanks a lot for the clear answer! It is working very well!

[Michael Goldberg]

When I try to use this in a JQL such as;

project = "MyProject" AND status = Testing AND sprint.filter($.state != "closed").last()

or

project = "MyProject" AND status = Testing AND Sprint = sprint.filter($.state != "closed").last()

or

project = "MyProject" AND status = Testing AND Sprint is sprint.filter($.state != "closed").last()

I get a JQL error about expecting operator but got "(" or the character $ is a reserved JQL..

What am I doing wrong?

[Stepan Kholodov _Tempo_]

@Michael Goldberg 

The sprint.filter($.state != "closed").last() function is of the Formula column which is a functionality inside Structure. it is not possible to use it in a JQL query, you can only use it in the Formula column in a structure.

I hope this helps. If you need assistance with the Formula or have any other questions about Structure, please reach out to us directly through our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Naziya Parveen]

Thank you so much. How.where do I write formula structure ? Do I need to install any programming language?

Thanks,

Naziya

[Stepan Kholodov _Tempo_]

Hello @Naziya Parveen 

The Formula column uses its own language but you don't need to install anything  else - all you need to use the Formula is already present in Structure. You can find out more about how it works and learn how to use it in our documentation here.

If you need any assistance - please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)