Create new Calculated Metrics based on Multiple Users

I have a multi tiered problem that I’m trying to solve:

  1. I want to add a calculated member field that will incorporate assignee and any tagged person in the description
    Example: Person A is assigned to issue ABC-1 but Person B is mentioned in the description. Person A and Person B should both have issue ABC-1 under their names
  2. I need to add a calculated measure. Our company won’t let us do custom fields beyond what is out of the box. I have repurposed an “Additional Notes” field to have what are essentially story points. I need to get those values from the field and have them roll up under the calculated member field in part 1.

Result Desired:

Person | Effort Points (from customfield_123)


Person A | 1
ABC-1 | 1
Person B | 2
ABC-1 | 1
ABC-2 | 1