List users and issues, which were assigned to them

Evgenii

Hi

In order to see a workload, I need to make a list of users, and issues, to which they were assigned (even if now issues are not assigned to them) in last 7 days, for example. Is it possible?

I need something like this:

John Doe

• ISSUE 1 // Closed, assigned to John Doe 
• ISSUE 2 // Closed, assigned to John Doe
• ISSUE 3 // Closed, currently assigned to Mary Doe, but when issue in work, it was assigned to John Doe

I tried to make it with Structure, but no luck (

 

Egor Tasa [ALM Works]

Hi Udjin,

In Structure this would be a little tricky - you can do it, but you'd have to know all potential users. 

As a quick example: 

IF(jd, "John Doe", assignee)

jd variable need to be set as query match : assignee was "John Doe" AFTER "-7d"

However, if you need to group by all assignees, at the moment it is not possible. That is, you can make this hierarchy:

John Doe

-  Issue 1

Mary Jane, John Doe

-  Issue 2

 

but not

John Doe

- Issue 1

- Issue 2

Mary Jane

- Issue 2

We plan to add working with arrays to Formulas, but at the moment it is not possible.

Regards,
Egor Tasa

ALM Works