How can I sort groups by max(dueDate) for epics in this groups (Structure plugin)

[Степан_Сычёв]

i have a grouper "by fix version(s)" for epics:

I have got something like this:

abc-1.0.0
-epic 1 summary, duedate: 25/jan/19
-epic 2 summary, duedate: 05/feb/19

cde-1.0.0
-epic N summary, duedate: 01/feb/19
-epic T summary, duedate: 03/feb/19

The max due date for version is:

abc-1.0.0 - 05/feb/19
cde-1.0.0 - 03/feb/19

And I need to sort this groups in my structure by this version's due date to get this:

cde-1.0.0
-epic N summary, duedate: 01/feb/19
-epic T summary, duedate: 03/feb/19

abc-1.0.0
-epic 1 summary, duedate: 25/jan/19
-epic 2 summary, duedate: 05/feb/19

how can I do this? 

[Egor Tasa [ALM Works] · Accepted solution]

Hi Stepan,

Thanks for the question. Sorting can be achieved using Formula column. To that effect, please:

1. Add a new column, selecting Formula (you can name it anything, but let's say it is named Max Due).
2. Formula itself would be MAX#strict{duedate} 
3. Then add Sorting generator, select Attribute... and then select Max Due 

This way you will get groups sorted. You can even delete Max Due column itself afterwards. Please, let me know if this solution works for you.

Regards,

Egor Tasa

ALM Works

[Степан_Сычёв]

It works! Thank you so much!