How to get assignee for particular period(eg. Last Month,Last Year)

Questions & Answers
, ,
1

Hi ,

I want to see a Report/Table to show the issue assignee for particular period or range of dates. Example (Assignee of the ticket during January or before 3 months etc)

How do we get this report in eazyBI. Could you please help on this?

Regards,
Tamil

2

@ nauris.malitis Could you please help on this?

3

Hi @Tamil,

You could use a similar approach as described in this post: How to list all assignees of an issue - #2 by zane.baranovska. I adopted the formula to show all assignees during the selected period for issues that had assignee changes:

Issues_-__sandbox-_eazyBI
Issues_-__sandbox-_eazyBI1560×638 55.6 KB

Here is the formula:

Generate(
  --go through all Assignee users
  Filter(
    [Assignee].[User].Members,
    --check wheather user was assignee of the issue during selected period
    NOT IsEmpty([Measures].[Issues history]) ),
  --get assignee names separated by comma
  [Assignee].CurrentMember.Name,
  ","
)

Lauma / support@eazybi.com