Salesforce’s native reporting can’t track first occurrence of accounts when you group by time periods because the grouping functionality resets unique value calculations for each time bucket.
You’ll learn how to overcome this limitation by combining real-time Salesforce data with advanced spreadsheet formulas to track true first occurrences across weekly groupings.
Track first occurrence data using Coefficient
CoefficientSalesforceSalesforcesolves this problem by importing yourdata into spreadsheets where you can use advanced formulas alongsidedata. This approach lets you calculate first occurrences across the entire dataset rather than being limited by grouped time periods.
How to make it work
Step 1. Import your training task data from Salesforce.
Use Coefficient to import Task records with fields like Account ID, Account Name, Activity Date, and Subject. Filter for training activities using a custom SOQL query:. This gives you all training activities for the current year.
Step 2. Calculate first occurrence dates for each account.
Add a helper column with the MINIFS formula:where column C contains Activity Dates and column B contains Account IDs. This formula identifies the earliest training date for each account across your entire dataset, not just within individual weeks.
Step 3. Create weekly groupings that preserve first occurrence data.
Add another helper column using the WEEKNUM formula:to group activities by week. Then use UNIQUE and FILTER functions to show only first occurrences per account while maintaining the weekly structure.
Step 4. Build your summary dashboard with running totals.
Create a pivot table showing accounts by week of first training. Include a cumulative count of unique accounts trained year-to-date using formulas that reference your first occurrence calculations. Set up automatic refresh schedules to keep your data current without manual updates.
Get accurate first occurrence tracking
Start trackingThis approach gives you true first occurrence tracking with weekly granularity that Salesforce reports simply can’t provide.your first occurrences accurately today.