Column to Display Assignee of Child based on Max Value Points

Question

Hello,

I am a newbie in Community and struggling with the following challenge:

I managed to get the max value points of items of "Type_B" onto the top level of this structure (using max#subtree {condition}). But I am struggling with getting the assignee (or any other field) into the top line, that is assigned to a descendant item of "Type_B" with the highest value points (20 in the example).
The example is a bit simplified as there are more levels with parent child links possible in my "real" challenge.

Any suggestions how to takle this. My appreciations in advance!
Georg

Bill Sheboy · Answer

Thanks for clarifying, Georg.  I am not familiar with that for Jira Server and so did not recognize it.  As someone from Tempo has provided a suggestion I recommend continuing with that thread.  Thanks!

Stepan Kholodov · Answer

I'm afraid there isn't enough details about your setup to recommend anything specific - a right formula is often fitted for the structure where it's used. Please reach out to our support portal and we'll have a deeper look into your use-case.

Best regards,
Stepan Kholodov
Tempo

Georg Bauser · Answer

Hello @Stepan ,

Thanks for your suggestions:

I think that your formula would return in my example "User_D".
I am not looking for the Assignee with the highest Value if you sort all assignee names.

What I want is:
In a line of JIRA "Type A" return the Assignee of the JIRA Items of "Type_B" that has the highest "Value Points" (=20 )".

Do you have a further suggestion? I would appreciate it a lot!

Truly kind Regards
Georg