Objective: I am trying to find the number of people - per week - who visit BOTH our "Offers" and "Rewards" pages. And I need to trend this audience over time.
What did I try?: I created two filters - one for Persons visiting the "Offers" path, and another for the "Rewards" path. I then created a Freeform table, with Week as the table index, and People as the metric. Lastly, I stacked both filters on the People metric, with the intention of filtering people who visited BOTH "Offers" and "Rewards" pages by week.
Result: When the global project date range filter is restricted to a specific week, the result is as expected - I get around 560K people. However, when this date range is expanded, the result balloons to over 2.3M, which is obviously incorrect, since the max cannot exceed the minimum size of these two audiences, which is around 820K.
Ask: How do I get the freeform table to only apply the Filter criteria for the individual weeks of the freeform table, and not the entire project date range.
I've attached an outline of how the audience is getting built up.