-
1. Re: How to have a FIXED calculation consider a selected filter value?
Deepak RaiJun 26, 2018 8:18 PM (in response to Phil R)
Hi Phil,
Here it Is
ALWAYS ADD FILTERS TO CONTEXT WITH FIXED LOD
These are the Calcs you need in your Situation:
For 25 Weeks
For 18 Weeks
FOR 17
FOR All Subs and all Weeks
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to Close Thread
-
2. Re: How to have a FIXED calculation consider a selected filter value?
Phil R Jun 27, 2018 8:21 AM (in response to Deepak Rai)Hi Deepak, I am trying to get a distinct subscriber count by the total number of events they have had based upon the [Weeks between subscription and event] filter - the sum of subscriber counts should not exceed the number of unique subscriber ids in the dataset. In this case, that is 46.
So for example:
- When the user selects 2 weeks, I need this subscriber to be counted only once under 3, because they have had 3 events as of 2 weeks between subscription and events.
- When the user selects 8 weeks, then the subscriber should be counted only once under 5, because they have had 5 events as of week 8.
subscriber id subscription date event date event date - subscription date weeks between event date and subscription date event count 7920 1/30/2017 2/6/2017 7 1 1 7920 1/30/2017 2/10/2017 11 1 1 7920 1/30/2017 2/15/2017 16 2 1 7920 1/30/2017 3/27/2017 56 8 1 7920 1/30/2017 4/1/2017 61 8 1 7920 1/30/2017 4/3/2017 63 9 1 7920 1/30/2017 4/27/2017 87 12 1 7920 1/30/2017 5/12/2017 102 14 1 7920 1/30/2017 7/31/2017 182 26 1 Please let me know if I can clarify anything else. Thanks!