How to list all assignees of an issue

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

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,
  ","
)

Best,
Zane / support@eazyBI.com

2 Likes

Thanks a lot!Your answer really wroked!

Hi @liu.jingjing

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

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

Hi Zane,

Can I apply this formula to the Assignee field? It seems it cannot use in the Assignee field but can apply to the Measures.

Thanks!

The calculation generates a piece of descriptive information – the list of Assignees related to the selected issue for each report row. It is designed for the Measures and won’t work as a calculated member in the Assignee dimension.

Generate(
  --go through all Assignee users
  Filter(
    [Assignee].[User].Members,
    --check whether 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,
  ","
)

If you prefer to see each Assignee as a separate row next to the issue, you can add Assignee dimension on report rows and select measure “Transition to Assignee” on columns. Filter rows by “Transition to Assignee” with a value > 0 for

The measure “Transition to assignee” also included the event of unassigning from some users. The (unassigned) would show up in the generated list.

If an issue has never been assigned and still is unassigned, then no user names would show up in the List of assignees. But you may adjust the calculation and add one more filter criterion to specially check on the current assignee using the measure “Issues created”:

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 
    --additional check for the current assignee to include never-assigned issues
    OR
    ([Measures].[Issues created],
    [Time].CurrentHierarchy.DefaultMember) > 0
    ),
  --get assignee names separated by comma
  [Assignee].CurrentMember.Name,
  ","
)