# 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:

1. In All items on the Datasets tab, select your DailyAggregation dataset.

2. Under Bar Length, click **Count of Rows**.

3. Click **Unique**.

4. Select **user_id_token**.

5. Select **Charts**.

6. Click **Column**.

7. Under Bars, click **+** and search for `timestamp_DMY`.

8. Select **Year-Week**.

9. Click **Save**.

10. Name your lens `Weekly Unique Users`.

11. Select your PartnerIntelligence app.

12. Click **Save**.

## Example

![A sample Weekly Unique Users CRM Analytics lens](https://a.sfdcstatic.com/developer-website/sfdocs/platform-pkg-exchange/media/pkg2\_dev/app_analytics_cookbook_recipe_csm_weeklyuu.png)

SAQL:

```nolang
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;

```