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] · Accepted solution]

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

[Evgenii]

Hi, Egor. 

Thanks for your answer. 

It looks like a good temporary workaround. Do you have an information, when, approximately, arrays to formulas will be ready?

This variant is suitable

John Doe

-  Issue 1

Mary Jane, John Doe

-  Issue 2

[Egor Tasa [ALM Works]]

Hi Udjin,

Hard to say when it will be available, this requires a lot of work, so there is no ETA yet.

For what you find a suitable variant, the formula would be

CONCAT(IF(jd, "John Doe "), IF(mj, "Mary Jane "))

Regards,
Egor