Calculating Number of Unique Requester Name

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?

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.

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

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

1 Like