# Number of closed issues where only specific user logged time

**URL:** <https://community.eazybi.com/t/number-of-closed-issues-where-only-specific-user-logged-time/2588>\
**Category:** Questions & Answers\
**Created:** [August 2, 2019, 3:11pm UTC](https://community.eazybi.com/t/number-of-closed-issues-where-only-specific-user-logged-time/2588 "2019-08-02T15:11:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ionsecrieru](https://community.eazybi.com/letter_avatar_proxy/v4/letter/i/b9e5f3/32.png) [@ionsecrieru](https://community.eazybi.com/u/ionsecrieru)\
**Post date:** [August 2, 2019, 3:11pm UTC](https://community.eazybi.com/t/number-of-closed-issues-where-only-specific-user-logged-time/2588/1 "2019-08-02T15:11:15Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [August 14, 2019, 8:47am UTC](https://community.eazybi.com/t/number-of-closed-issues-where-only-specific-user-logged-time/2588/2 "2019-08-14T08:47:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ionsecrieru](https://community.eazybi.com/letter_avatar_proxy/v4/letter/i/b9e5f3/32.png) [@ionsecrieru](https://community.eazybi.com/u/ionsecrieru)\
**Post date:** [August 16, 2019, 8:20am UTC](https://community.eazybi.com/t/number-of-closed-issues-where-only-specific-user-logged-time/2588/3 "2019-08-16T08:20:58Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [August 16, 2019, 11:48am UTC](https://community.eazybi.com/t/number-of-closed-issues-where-only-specific-user-logged-time/2588/4 "2019-08-16T11:48:18Z")

</div>

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