Create a Custom Object Updates Per Day Recipe

This recipe produces a unique count of how many times per day a custom object was created.

In your org in Analytics Studio in CRM Analytics:

In All items on the Datasets tab, select your DailyAggregation dataset.
Select Charts.
Click Column and leave Bar Length as Count of Rows.
Under Bars, click + and select timestamp_DMY.
Select Year-Month-Day.
Click the Filters tab.
Click +.
Select custom_entity_type Equals CustomObject
Click Apply.
Click +.
Select operation_type Equals UPDATE.
Click Apply.
Click the Data tab.
Under Trellis, click +.
Select custom_entity.
Click Save.
Name your lens Custom Object Creates Per Day.
Select your PartnerIntelligence app.
Click Save.

Example

A sample Custom Object Updates Per Day CRM Analytics lens

SAQL:

1q = load "DailyAggregation";
2q = filter q by 'custom_entity_type' == "CustomObject";
3q = filter q by 'operation_type' == "UPDATE";
4q = group q by ('timestamp_derived_DAY_formula_Year', 'timestamp_derived_DAY_formula_Month', 'timestamp_derived_DAY_formula_Day', 'custom_entity');
5q = foreach q generate 'timestamp_derived_DAY_formula_Year' + "~~~" + 'timestamp_derived_DAY_formula_Month' + "~~~" + 'timestamp_derived_DAY_formula_Day' as 'timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month~~~timestamp_derived_DAY_formula_Day', 'custom_entity' as 'custom_entity', count() as 'count';
6q = order q by ('timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month~~~timestamp_derived_DAY_formula_Day' asc, 'custom_entity' asc);
7q = limit q 2000;