Formula to set group by row to value in same formula that sets value for items in the group

larry joseph

I have a column based on a formula that I am grouping by and want to sort the groups.  I have been able to do this by having two formulas. 

1. is a formula for a column called deploy month, and puts the values on the individual items in the group.  I use that for the group by.

2. is a second column that does a max#subtree{deploymonth} referencing the field from step 1, and sets the deploy month for the group's row.  I sort by that.

 

Is there anyway to do it all in one formula / column so that the individual rows get the calculated deploy month value, and the group by row would get the max of it's children so it has a value that can be sorted on?  I tried to create a single formula but got stuck trying to map the variable for the deploymonth.

Stepan Kholodov

Hello @larry joseph 

if the sorting of groups has to be done by a number, then the only way to achieve it with a single formula if the number is added to the groups' names right away, i.e. for the formula to create a groups with names like '1 - January', '2 - February' etc by at the same time extracting the deployment month from the issues and the latest month of the issues. In this case, you can have one formula used for grouping and then you can sort the groups by adding the Sort by Summary generators - it will order the groups based on the numbers in their summaries.

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

Best regards,
Stepan
Tempo (the Structure app vendor)