This content has been marked as final.
Show 4 replies

1. Re: Counting the distinct members of a set based on a parameter value over time
Prayson Wilfred Daniel Jul 21, 2017 12:01 AM (in response to Isha Garg)How about this: N is the parameter which takes int e.g. 100
COUNTD( IF {FIXED [ID],DATETRUNC('month', [Purchase Date]): SUM([Product Unit])} > [N] THEN [ID] END)
Example: Finding customers ID that has more than 3 order in a month (Sample Store Data)

Book2.twbx 7.0 MB


2. Re: Counting the distinct members of a set based on a parameter value over time
Isha Garg Jul 20, 2017 11:54 PM (in response to Isha Garg)Thank you so much. I have been banging my head from last two days with this. Thank you.

3. Re: Counting the distinct members of a set based on a parameter value over time
T G Jul 20, 2017 11:57 PM (in response to Isha Garg)Hello Isha,
Refer the below snapshot. If you are looking for this, follow the approach as highlighted. Workbbok 10.2 is also attached.
TG

Top N Products.twbx 1.2 MB


4. Re: Counting the distinct members of a set based on a parameter value over time
Prayson Wilfred Daniel Jul 21, 2017 12:02 AM (in response to Isha Garg)You are welcome!