# Calculating Number of Unique Requester Name

**URL:** <https://community.eazybi.com/t/calculating-number-of-unique-requester-name/10000>\
**Category:** Questions & Answers\
**Created:** [July 11, 2022, 4:38pm UTC](https://community.eazybi.com/t/calculating-number-of-unique-requester-name/10000 "2022-07-11T16:38:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![psoulier](https://community.eazybi.com/letter_avatar_proxy/v4/letter/p/8491ac/32.png) [@psoulier](https://community.eazybi.com/u/psoulier)\
**Post date:** [July 11, 2022, 4:38pm UTC](https://community.eazybi.com/t/calculating-number-of-unique-requester-name/10000/1 "2022-07-11T16:38:35Z")

</div>

I need to know within the Incident issue type, how many unique requester names were entered within a given month.  
Is there a way to calculate number of Unique Requester Name within a timeframe?  
If so, what would that calculation be?

---

<div class="post-metadata">

**Author:** ![oskars.laganovskis](https://community.eazybi.com/user_avatar/community.eazybi.com/oskars.laganovskis/32/5902_2.png) [@oskars.laganovskis](https://community.eazybi.com/u/oskars.laganovskis)\
**Post date:** [July 18, 2022, 12:32pm UTC](https://community.eazybi.com/t/calculating-number-of-unique-requester-name/10000/2 "2022-07-18T12:32:54Z")

</div>

Hi @psoulier,

Assuming that there is only one requester per issue and you have imported the requested field as a dimension, you might use the following expression to count the requesters within a specified time period.

```auto
NonZero(
 Count(
  Filter(
   DescendantsSet([Requester].CurrentHierarchyMember,[Requester].[Requester]),
 [Measures].[Issues created]>0)
))

```

This expression goes through the Requester dimension and counts the requesters who have had issues registered.

Regards,  
Oskars / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![psoulier](https://community.eazybi.com/letter_avatar_proxy/v4/letter/p/8491ac/32.png) [@psoulier](https://community.eazybi.com/u/psoulier)\
**Post date:** [July 18, 2022, 8:00pm UTC](https://community.eazybi.com/t/calculating-number-of-unique-requester-name/10000/3 "2022-07-18T20:00:15Z")

</div>

Hi Oskars,

Since the field name is ‘Requester Name’, here it the code I used:

NonZero(  
Count(  
Filter(  
DescendantsSet([Requester Name].CurrentHierarchyMember,[Requester Name].[Requester Name]),  
[Measures].[Issues created]\>0)  
))

Appears to have worked as expected.  
Thanks,  
Pat