Need Help Identifying Inactive Users in EazyBI

[Miqueas_Milanesio]

Hi!,

I’m currently working on activity reports in EazyBI and facing a challenge in identifying inactive users within our Jira instance. I’ve been using a Jira filter that works well, but I’m struggling to replicate the same functionality in EazyBI. Here’s what I’ve tried so far:

In Jira, I’m using the following JQL filter to find inactive users:

" assignee in (inactiveUsers()) AND statusCategory != Done ORDER BY assignee ASC "

My goal is to achieve the same result in EazyBI. I attempted to create a calculated member in the Assignee Dimension with the following formula:

Aggregate(
Except([Assignee].[User].Members,
Filter([Assignee].[User].Members,
[Assignee].CurrentMember.Name MATCHES ‘.[X].’)
))

However, this approach didn’t yield the desired results. I would greatly appreciate it if someone could provide guidance on how to correctly identify inactive users in EazyBI based on the criteria used in the Jira filter.

Thank you for your assistance!

[martins.vanags]

@Miqueas_Milanesio

Please check these two other community threads on how to filter report by active users

Filter on active user

Hi, Thanks for the clarification. Currently, eazyBI does not import the attribute “active” (and “inactive”) for any user dimension. You can import this attribute as additional property for any user with additional data import. Then you can use this property to filter out active users only by creating a new calculated member which aggregates user dimension member by new property https://docs.eazybi.com/display/EAZYBIJIRA/Additional+data+import+into+Jira+Issues+cube Or you can try creating a c…

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

Martins / eazyBI

[Miqueas_Milanesio]

I finally achieved it by importing via Rest API,

Using:
/rest/api/latest/users/search?&maxResults=2000

And applying the following mapping:

[Nanda]

Hello @Miqueas_Milanesio,

Can you share with us the javascript you used to achieve this?

Thanks!

[Miqueas_Milanesio]

Hi @Nanda

The JavaScript codes I used were simply to tidy up the data I obtained. Here’s what I used:

accountId:
if (doc.accountType === “atlassian”) {
return doc.accountId;
} else {
return “”;
}

active:
return doc.active.toString().replace(“true”, “Activo”).replace(“false”, null )

Inactivo:
return doc.active.toString().replace( null , “Inactivo”).replace(“Activo”, null )

Usuarios activos:
return doc.active.toString().replace(“Activo”, “1”).replace( null , “0”)

I hope you find it useful.