How to list all assignees of an issue

Feature Requests
1

Hi, all:
I want to know how many assignees that an issue had ever been assigned to,and list them.
Is it possible？
Thanks in advance

2

Hi @liu.jingjing,

Yes, you can see all previous assignees of an issue. The assignee change history is imported in eazyBI, and you can see previous assignees using measures “Issue history” or “Transitions to assignee” together with Assignee dimension. For more details on the available historical measure, please see the documentation: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history

For listing assignee names in one field, you might want to create a new calculated measure (in Measures) based on historical measure “Transition to assignee” and Assignee dimension. Use function Generate() to get a list of assignee names (https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/generate).
The formula might look like this:

Generate(
  --go through all Assignee users
  Filter(
    [Assignee].[User].Members,
    --check wheather user was assigned to issue at some point
    ([Measures].[Transitions to assignee],
    [Time].CurrentHierarchy.DefaultMember) > 0 ),
  --get assignee names separated by comma
  [Assignee].CurrentMember.Name,
  ","
)

List of Assignees
List of Assignees2212×1006 253 KB

Best,
Zane / support@eazyBI.com

1 Like
3

Thanks a lot！Your answer really wroked！

5

Hi @liu.jingjing

I was unable to understand the configuration used, could I make a copy of this panel available?

6

This seems to fail if the current user is unassigned, ie, Issue Assignee is “Unassigned” from an earlier assignee ! Can that be fixed ?