Create a Weekly Unique Users Recipe
This recipe produces a unique count of users by week.
In your org in Analytics Studio in CRM Analytics:
- In All items on the Datasets tab, select your DailyAggregation dataset.
- Under Bar Length, click Count of Rows.
- Click Unique.
- Select user_id_token.
- Select Charts.
- Click Column.
- Under Bars, click + and search for timestamp_DMY.
- Select Year-Week.
- Click Save.
- Name your lens Weekly Unique Users.
- Select your PartnerIntelligence app.
- Click Save.
Example

SAQL:
q = load "DailyAggregation";
q = group q by ('timestamp_derived_DAY_formula_Year', 'timestamp_derived_DAY_formula_Week');
q = foreach q generate 'timestamp_derived_DAY_formula_Year' + "~~~" + 'timestamp_derived_DAY_formula_Week' as 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Week', unique('user_id_token') as 'unique_user_id_token';
q = order q by 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Week' asc;
q = limit q 2000;