Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.
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

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;