A report to display active users?

I need to display the following:

Number of Registered users in the Portal by month
Number of active users in the Portal by month

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

1 Like