Create a Custom Object Reads Per Day Recipe
This recipe produces a unique count of how many times per day a custom object was
read.
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 READ.
- Click Apply.
- Click Data.
- Under Trellis, click +.
- Select custom_entity.
- Click Save.
- Name your lens Custom Object Reads Per Day.
- Select your PartnerIntelligence app.
- Click Save.
Example

SAQL:
q = load "DailyAggregation";
q = filter q by 'custom_entity_type' == "CustomObject";
q = filter q by 'operation_type' == "READ";
q = group q by ('timestamp_derived_DAY_formula_Year', 'timestamp_derived_DAY_formula_Month', 'timestamp_derived_DAY_formula_Day', 'custom_entity');
q = 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';
q = order q by ('timestamp_derived_DAY_formula_Year~~~timestamp_derived_DAY_formula_Month~~~timestamp_derived_DAY_formula_Day' asc, 'custom_entity' asc);
q = limit q 2000;