Column to Display Assignee of Child based on Max Value Points

[Georg Bauser]

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]

Hi @Georg Bauser -- Welcome to the Atlassian Community!

In which tool are you trying to do this?  This does not appear to be inside of Jira.

You posted this question in the Jira Software community, but this seems like a question for a spreadsheet tool.  If that is the case, I recommend trying an Internet search for this, focused on your specific tool.

Kind regards,
Bill

[Georg Bauser]

Hi @Bill Sheboy ,
Iam using Jira v9.4.11 + ALM Structure 
My question is related to ALM Structure. Is this wrong community?

Regards
Georg

[Bill Sheboy]

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 _Tempo_]

Hello @Georg Bauser 

If all issues are present in the structure and they are added in a form of a hierarchy, then you can extract min and max values of descendants and show them at the highest Type A issue with a formula like this:

if issuetype = "type A": max{if issuetype != "type B" and issuetype != "type C": assignee}

the approach here is to define the issues under Type B, so the formula would only consider their values. If such issues are of a different issue type, then you can just define this type; or if they have any other unique afield value, it can be used as well.

I hope this helps. If you need further assistance, please reach out to us directly at our support portal and we will get back to you shortly.

Best regards,
Stepan Kholodov
Tempo (The Structure app vendor)

[Georg Bauser]

Hello @Stepan Kholodov _Tempo_ ,

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 

[Stepan Kholodov _Tempo_]

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