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