Count issues with unique values in custom field

Questions & Answers
1

Hello,

I would like to create a report which shows the number of issues created per week but count them only once for each unique value in the custom field “Material number”.

So for example if in one month the following tickets were created:
Ticket 1 (Material number: M1)
Ticket 2 (Material number: M1)
Ticket 3 (Material number: M2)
then the report should show only two tickets since tickets exist only for two distinct material numbers.

How can I achieve this?

Thank you
Johannes

2

Hi, Johannes,

The following formula counts the number of dimension members having at least one ticket created in the week:

NonZero(Count(
  Filter(Descendants([Material number].CurrentMember,[Material number].[Material number]),
  [Measures].[Issues created]>0)
))

Kindly,
Janis, eazyBI support

1 Like
3

Hi Janis,

works like a charm.

Thanks a lot!