Exclude Assignee from report


#1

Hi,
i have question about excluding people from report.
For example - i have report with issue closed per assignee in month.

But there is one person who is additional and i don’t want to see him in this report. I could use Assignee pages, select all, and deselect this person, although it’s not the best solution.

Is there a way to make a group of all assignee without this person? I tried to make a Calculated Member in Assignee group, but it works as a sum of all member without this one, not like a group of people that i need.


#2

Hi @strojna.ewa,

Yes, you may create a group of all assignees except one particular or several users. In Assignee dimension define a new calculated member which aggregates all users except listed user or users:

Aggregate(
  Except(
    --set of all assignees
    [Assignee].[User].Members,
    --list of user names which should be excluded
    { [Assignee].[Admin Shakespeare] }
  )
)

More information on how to create calculated members in the dimension using functions Aggregate() and Except() you will find in the documentation:
https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members#Calculatedmembers-Aggregatemembersinotherdimensions

Best,
Zane / support@eazyBI.com


#3

Hi, @zane.baranovska,
thanks for your reply, it works well :slight_smile: