I would like to filter out users in my EasyBI reports that are inactive in Jira. Thus far I’m unable to figure out how to accomplish this. Any help would be greatly appreciated.
Maybe try adding the following to the Assignee dimension and then add it to the page filter.
[Assignee].CurrentMember.Name MATCHES ‘.[X].’
Aggregate( Except([Assignee].[User].Members, Filter([Assignee].[User].Members, [Assignee].CurrentMember.Name MATCHES '.*[X].*') ))
Martins from the eazyBI support has also provided another option that retrieves the user activity data from the Jira via SQL query.
You might read that here Filter on active user - #7 by martins.vanags.
Oskars / support@eazyBI.com