Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards

CJA Applying Filter Conditions to Global Date Range, instead of Freeform Table Date Range

Avatar

Level 1

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. 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

I'm not sure if there's a way to do this without creating specific segments for each week. One sort of similar way you could easily do this in CJA is to create another data view with a longer session timeout period (say 1 week). You could then filter for sessions where both pages were engaged in the same session.