Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,203
Community Members
 
Community Events
165
Community Groups

Structure: How to search the history of each issue for assignees

In a structure, I want a list of all users who have ever worked on a project within a certain time period. I.e. if in the course of a story a total of 3 people have worked on it, then I want to see the number 3. So I need to search the history of each issue by user

1 answer

0 votes

Hello @peter_dickermann ,

David from ALM Works here. .

Assuming you are utilizing Jira's time tracking, you can use a formula like this:

SIZE(UNIQUE(
worklogs.FILTER($.MAP(DAYS_BETWEEN($.created,today())<30)).author))

The worklogs.FILTER part identifies the worklogs array and filters out the records that were created in the past 30 days, then returns the author of the worklog. (you can adjust the 30 to meet your desired timeframe).

The UNIQUE & SIZE part looks at the new filtered array and then counts each unique occurrence of the author.  So, if you have the same person log several pieces of work during the timeframe, it will only count them once.

If instead you wanted just a list of names of the people who worked on the issue, you can drop the SIZE piece of the formula.  It would look like this:

UNIQUE(
worklogs.FILTER($.MAP(DAYS_BETWEEN($.created,today())<30)).author)

Please let me know if this helps.

Best,
David

Hi David,

thank you for the support. No, it didn't help so far, but I think the reason for that is either that I have no experience with the expressions you've sent and/or I didn't explain the issue well enough.

For each assignee I'd like to see the number of issues he's been working on in the actual year. So far, I get only the number of issues he is currently working on.

Thank you,

Peter
Untitled.png

Hello @peter_dickermann ,

Is 40 the number of issues the first user is currently working on?

How do you define "worked on"? Seems to be Assignee based on what i see in the screenshot.

The way I understand it at the moment is you have a structure that shows active issues, grouped by assignee.  You want to have a column that shows the total number off issues where the user was the assignee for the current year.  (These issues do not currently exist in the structure). 

Is this correct?

Best,
David

Hi David,

yes, 40 is the number of issues the first user/assignee is working on currently.

Yes, I want to have a column that shows the total number off issues where the user was the assignee for the current year

Best,
Peter

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you