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()

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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()

Accepted answers

Qasem O

@Joseph Wilkinson

I hope this assist you

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

All comments

Qasem O

@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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-data-center

data-center