Count members of Tempo Team

Questions & Answers
,
1

Hi,

i was trying to count members of Tempo Teams (Logged by Team) but i always got 1.

I tried:

[Logged by].CurrentMember.Count

and

Count(
[Logged by Team].CurrentMember
)

and

Count(
Descendants([Logged by Team].CurrentMember.Children)
)

but it didn’t got me expected amount, only 1 or 0. :frowning:

How can i write this measure?

2

Hi @strojna.ewa

Try creating a new calculated measure using this formula:

NonZero(
Count(
Filter(
Descendants([Logged by].CurrentHierarchyMember,[Logged by].[User]),
[Measures].[Hours spent]>0
)
)
)

It would count users from the “Logged by” dimension that have logged hours in the report context.

Martins / eazyBI team

3

Thank you , but how to count all the team members even if they not log time?

I mean, in this measure i’ve got number of people from this team who logged time, but i want to know the number of the Team members regardless if they log time or not.

4

Hi,

“Logged by” dimension has only those users that has logged at least 1 time entry on imported issues.
Otherwise, the user won’t be found in this dimension and this approach won’t work.

eazyBI imports data based on issues and worklogs.
Inactive users are not imported in eazyBI.

see more details about the general user dimension here

The closest you could perhaps do is changing the formula so it searches for user worklogs through out whole history of issues (not just particular period of time)

NonZero(
Count(
Filter(
Descendants([Logged by].CurrentHierarchyMember,[Logged by].[User]),
([Measures].[Hours spent],[Time].Currenthierarchy.DefaultMember)>0
)
)
)

This calculation would check if the “Logged by” dimension member has logged time for the imported issues at all, no matter of when.

Martins / eazyBI support

1 Like
5

Thank you, everything clear

6

Sorry to open this thread again. Logged by gets you all the users (even if the user is not part of the Tempo Team). Is there a way to get only the members defined in the Tempo Team (as setup in JIRA)? Does this require any new admin setting to load this into eazyBI? It is OK if any of the Tempo team member did not log any time for the selected time/sprint.

7

@isnrao

Try importing “Logged by Team” dimension and use it to filter your report.
https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/tempo#Tempo-Dimensionsforworklogsandcustomfields

Martins / eazyBI team