Jira Structure: Count Unique assignee

[Joseph Wilkinson]

Hi Atlassian Community, hope you can help pinpoint where I'm getting stuck.

Using Jira Structure I have a list of Epics.  Contained within each Epic is a list of Story, Bugs, and/or Tasks assigned to various engineers across different teams.  I would like to sum the number of unique engineers specific assigned to specific to each team.  

So for example:

- Epic 1 contains the following issues assigned to engineers across specific teams:

• Story 1:
  • Team A
  • Assignee = Joe Smith
• Story 2:
  • Team A
  • Assignee = Jane Doe
• Story 3:
  • Team A
  • Assignee = Joe Smith
• Story 4
  • Team B
  • Assignee = Bruce Wayne
• Story 5
  • Team B
  • Assignee = Bruce Wayne

The results I'm looking for would be the following:

• Team A = 2        Team B = 1
  • (I'm just looking for the total number of unique engineers assigned)

I tried using the following formulas but what results is a total sum.  It doesn't exclude in the sum if the assignee is already counted

if (
     (issuetype = "Story" OR issuetype = "Task" OR issuetype = "Bug")
     AND (Engineering_Team = "Team A")
     AND assignee.unique(),
     1,0)

if (
(issuetype = "Story" OR issuetype = "Task" OR issuetype = "Bug")
AND Engineering_Team = "Team A" ,
VALUES{ assignee }.unique().size()
)

Hoping there is a way to make this work vs updating the formula to specifically look at Assignee = Jane Doe and summing tha way

UPDATE:  This seems to have gotten me very close but now I just need to figure out how to specify the Engineering Team

- UNIQUE(VALUES#children{assignee.name}).size()

[Qasem O · Accepted solution]

Hi

@Joseph Wilkinson 

I hope this assist you

{Joe smith:teamA,Jane Doe:teamA,Bruce Wayne:team B}

[Joseph Wilkinson]

@Qasem O thanks for your input.  Do you think there is a way to configure the formula so that I don't have to include the names of the individual assignees?  This is what I'm trying to avoid as the list of assignees would be very long.

With this formula:  UNIQUE(VALUES#children{assignee.name}).size() using the above example the total is 3.  So on the right track.  But now I can't figure out how to update the formula to specifically look for Team A or Team B

Thank you for your input and help

[Stepan Kholodov _Tempo_]

Hello @Joseph Wilkinson 

You need to connect the assignees with their teams somehow since Structure isn't aware to which team each assignee belongs to. You can define the connection in the formula by listing each possible assignee and their team. 

Alternatively, you can add a Group generator and additionally group Stories by the Team field, if it exists. In this case, you will end up with the hierarchy like this: Epic -> Team group -> Story. And then, the Formula column can count the number of unique assignees for each group like this:


if !issuetype and parent{issuetype = "epic"}: array#children{assignee).unique()

you can also add .size() at the end of the formula if you just want to to see the number of unique assignees per each group.

I hope this helps. If you need further assistance here or if you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Joseph Wilkinson]

Thanks @Stepan Kholodov _Tempo_ what you described above is the best path so far.  I used a group generator to group the issues (Story, Tasks) contained within an Epic to group issues by Engineering Team.  Then I used this formula UNIQUE(VALUES#children{assignee.name}).size() to calculate the number of Unique Assignees.

I think this is the best solution at the moment.  Thank you for the help