EazyBI Reports to display active users

[Vedant Kulkarni]

I have the following requirement.

Number of Registered users in the Portal by month

Number of active users in the Portal by month

Is this possible using EazyBI?

[Daina Tupule eazyBI · Accepted solution]

eazyBI supports reports with Jira users if they played some role in issues. For example, Assignees, Reporters, etc.

There could be a case you would like to count customers who registered some issues in Jira Service Desk portal. You can use a Reporter dimension for this and count reporters of a specific group (that could represent customers and ignore company internal users).

NonZero(Count(
  Filter(Descendants([Reporter].CurrentMember,[Reporter].[User]),
    CoalesceEmpty([Reporter].CurrentMember.get("Groups"),"")
     MATCHES ".*(^|,)<exact customer group name>($|,).*"
    AND 
    [Measures].[Issues created]>0 
  )
)
)

Please use correct name instead of 

<exact customer group name>

Daina / support@eazybi.com

[Vedant Kulkarni]

@Daina Tupule eazyBIthanks, this is what we wanted.