Create a Monthly Unique Users Recipe

This recipe produces a unique count of users by month.

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-Month.
Click Save.
Name your lens Monthly Unique Users.
Select your PartnerIntelligence app.
Click Save.

Example

A sample Monthly Unique Users CRM Analytics lens

SAQL:

1q = load "DailyAggregation";
2q = group q by ('timestamp_derived_DAY_formula_Year', 'timestamp_derived_DAY_formula_Month');
3q = foreach q generate 'timestamp_derived_DAY_formula_Year' + "~~~" + 'timestamp_derived_DAY_formula_Month' as 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month', unique('user_id_token') as 'unique_user_id_token';
4q = order q by 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month' asc;
5q = limit q 2000;