Most Recent Opportunity Close Date Problem: How do you calculate the most recent close date of a closed child Opportunity for each parent Account record? Account, MAX, Opportunity, Dates, Pre-Built rollup
Number of Email Tasks under a Contact Problem: How do you calculate the amount of "Email" Tasks for each Contact record? Account, Contact, COUNT, Task, Email, Pre-Built rollup
Number of Contacts without an Email Address Problem: How do you calculate the amount of Contacts without an email address assigned for each Account record? Account, Contact, Email, Pre-Built rollup
Number of Contacts under an Account Problem: How do you calculate the the number of Contacts for each Account record? Account, Contact, COUNT, Pre-Built rollup
Most Recent Email Date Problem: How do you calculate the latest Task Activity Date with type "Email" for each Contact record? Contact, Task, Email, Dates, Pre-Built rollup
Most Recent Campaign Date Problem: How do you calculate the latest Created Date of all Campaigns for each Contact record? Contact, Campaign, Dates, Pre-Built rollup
Most Recent Call Date Problem: How do you calculate the latest Activity Date of all Tasks with the type "Call" for each Contact record? Contact, Activity Monitoring, Task, Pre-Built rollup
Largest Won Opportunity Amount Problem: How do you calculate the largest amount of a child Closed Won Opportunity for each parent Account record? Account, Opportunity, revenue metrics, Pre-Built rollup
First Opportunity Close Date Problem: How do you calculate the first close date for a child Opportunity for each parent Account record? Account, Opportunity, Dates, Pre-Built rollup
First Campaign Date Problem: How do you calculate the earliest created date of a child Campaign for each parent Contact record? Contact, Campaign, Dates, Pre-Built rollup