Filter by custom reporter names

Questions & Answers
1

Hi Team,

I have a list of reporter names (yy1@yy.com, yy2@yy.com etc…)I need to create a bar chart now to differentiate the issues reported by the above list vs rest of other reporters.

Can you please advise the best was to achieve this requirement, Please let me know for any questions.

Thank you

2

HI EazyBI Team,

Any help here please ?

3

Hi @naresh.srkr ,
You can create an aggregate member in the Reporter dimension to have a group with users.

Aggregate(
  {[Reporter].[Adam Mint],
  [Reporter].[Anna Linda],
  [Reporter].[Sandra Adams]}
)

Also, you can apply a filter in your aggregated member, if you have a common character for your users (e.g. email in username).

Aggregate(
Filter(
  [Reporter].[User].Members,
  [Reporter].CurrentHierarchyMember.Name MATCHES ".*yy.com.*"
  ))

With function except(), you can create a new member in the Reporter dimension to have users except for the ones above.

Aggregate(
  Except(
    [Reporter].[User].Members,
    {[Reporter].[Adam Mint],
    [Reporter].[Anna Linda],
    [Reporter].[Sandra Adams]}
  )
)

If you have groups in Jira, you can also explore the option of using Reporter Group in your report, see on how to import it here: Jira Issues Import - eazyBI for Jira

best,
Gerda // support@eazyBI.com