Structure - Sorting Group By Numericially

[larry joseph]

In Structure I want to group issues by sprint and sort it numerically.  The sprint name is for different teams and is in the format of Team Name Sprint #, ex XYZ Sprint 10, ABC Sprint 11 (sprint numbers are normalized across teams).

To do this I created a Group By and Sort using this formula to strip the sprint name down to just the sprint number:

if sprint = undefined : 9999 else number(replace(sprint,"* Sprint ")). I've also tried a variety of other formulas to force Structure to treat the data as numeric, but none have worked.

The formula works to get the sprints to just the number and groups the sprints together by number, but I cannot get it to sort numerically.  No matter what I try it only sorts as text. See screen shot of how it is working.  How can I get this to sort numerically?

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @larry joseph 

The Formula grouper creates text values, so groups are sorted accordingly. To treat them as numbers, you need to convert them first. You can do it by adding a Sort by Attribute generator with the formula: number(summary) and make sure that the sorter works on the level where the Formula based groups are located.

I hope this helps. Please reach out to us directly at our support portal if you have other questions about Structure.

Best regards,
Stepan
Tempo (the Structure app vendor)

[larry joseph]

@Stepan Kholodov _Tempo_thank you that worked.