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 Creates 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 search for timestamp_DMY.
- Select Year-Month-Day.
- Click Filters.
- Click +.
- Select custom_entity_type equals CustomObject.
- Click Apply.
- Click +.
- Select operation_type Equals INSERT.
- Click Apply.
- Click Data.
- 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' == "INSERT";
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;