Filter in EasyBI the Xray Test of the users who reported except one user

[Pablo_Andres_Cunarro]

I need a Query/filter for EazyBI that will bring me the number of Xray Tests created except one user that I don’t want from the “Reporter” field for exampel Pablo XXXXXX

[Pablo_Andres_Cunarro]

@zane.baranovska can you help me?

[ilze.mezite]

Hi, @Pablo_Andres_Cunarro

To filter out the Reporters you don’t want to see; please define the calculated member in the Reporter hierarchy using this formula:

Aggregate (
Except (
--All reporters
[Reporter].Children,
--except Pablo
[Reporter].[Pablo XXXXXX]
))

Then select this new member - not the “All Reporters”.

Kind regards,
Ilze support@eazybi.com