How to Group Assignees by Username Instead of Full Name in eazyBI?

Questions & Answers
, ,
1

Currently, I have a calculated measure in eazyBI that groups tickets by assignee. For example, I use something like this: [Assignee].[Luis Guillermo Espinoza Lopez] + [Assignee].[Jose Quintero]. This works perfectly, but I want to get the assignee by their username instead of their full name. This is because full names can change, which affects some reports, while usernames remain constant.

Could you help me find out if this is possible?

1 Like
2

Hi, @jequinterop

Welcom to the eazyBI community!

Yes, it is possible to reference assignees by their username instead of their full name. This approach is indeed more reliable as usernames typically remain constant even if full names change. Here’s how you can modify your formula to use usernames:

Aggregate({
  [Assignee].[User].GetMemberByKey("<<key goes here>>"),
  [Assignee].[User].GetMemberByKey("<<key goes here>>")
})
  • Aggregate() function is used to group multiple assignees together: Aggregate
  • GetMemberByKey() function is used to retrieve the member by its key: GetMemberByKey

Kindly,
Ilze

1 Like