Remove reporting of inactive users in EasyBI

Questions & Answers
3

Hi @Keithschug,
​
@Amit_Shil has provided a good hint on a possible option.
Unfortunately, it seems that the community formatting has changed the code slightly.

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.
​
​Regards,
​Oskars / support@eazyBI.com