Number of closed issues where only specific user logged time

Hi community,

can someone help me with a measure that calculates the:

number of closed issues where time was logged only by one or more specific users.

For instance, I need to see how many issues have time logged only by user1 or/and user2 which are part of Line 2 support team but not by user3 who is part of Line 3 support team or anyone else.

I’m new to all this. Will appreciate your help a lot!

Hi,
Welcome to eazyBI community.

In this case, you could create a new calculated measure in “Measures” dimension that would calculate the number of closed issues which have logged hours by one or multiple users

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Measures].[Issue closed date],
[Time].CurrentHierarchyMember
)
AND
[Measures].[Issues closed]>0
AND
Aggregate(
  {
    [Logged By].[John Smith],
    [Logged by].[Amanda Wilson]
  },
  [Measures].[Hours spent]
)>0
)
)
)

Try adjusting the code for your actual Logged By users (I provided samples in the code so far).
It should filter issues if they were closed and if they had logged hour in selected/displayed time period (if “Time” dimension is used at all)

Martins / eazyBI support

Hi @martins.vanags, thank you for your help.
At the moment, the measure you wrote is working but still showing issues where other people than “John” or “Amanda” logged time.
What I’m actually looking for is to get those issues where only John and Amanda logged the time and no one else.
Maybe you have an idea how to make that work?
Thanks,
Ion.

In that case, try this more sophisticated code:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Measures].[Issue closed date],
[Time].CurrentHierarchyMember
)
AND
[Measures].[Issues closed]>0
AND
Aggregate(
  {
    [Logged By].[John Smith],
    [Logged by].[Amanda Wilson]
  },
  [Measures].[Hours spent]
)>0
AND
IsEmpty(
Aggregate( 
	Except( 
	[Logged By].[User].Members, 
	{ 
		[Logged By].[John Smith], 	
		[Logged By].[Amanda Wilson] 
	}),
  [Measures].[Hours spent]
)
)

)
)
)

Martins / eazyBI support