)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce Activity dashboard filters only show lookup fields because Activities are polymorphic objects that can relate to multiple parent types, creating technical constraints that prevent formula and custom fields from appearing as filter options.
This limitation blocks access to critical filtering capabilities you need for comprehensive Activity reporting. Here’s how to bypass these restrictions entirely.
Access all Activity fields for filtering using Coefficient
The polymorphic nature of Activities means Salesforce can only expose direct lookup relationships like Account, Contact, Lead, and Opportunity in dashboard filters. Custom fields from related objects and formula fields remain inaccessible through native dashboards.
Coefficient eliminates this architectural limitation by importing your Activity data alongside related object data into Salesforce spreadsheets where every field becomes filterable.
How to make it work
Step 1. Import Activities with full field access.
Use Coefficient’s “From Objects & Fields” import to pull all Activity fields, including custom fields and related object data that dashboard filters can’t access. Select Task and Event objects to capture complete Activity information.
Step 2. Import User and related object data separately.
Create additional imports for User, Account, and other objects that contain the custom fields you need for filtering. This gives you access to fields like Sales Region, Territory, or custom categorizations stored on related objects.
Step 3. Join related fields using lookup formulas.
Use Coefficient’s =salesforce_lookup function to merge custom fields from related objects with your Activity data. For example: =salesforce_lookup(“User”, “Id”, A2, “Sales_Region__c”) pulls User custom fields directly into your Activity sheet.
Step 4. Create comprehensive filter controls.
Build dropdown filters using Data Validation that reference all your imported fields – whether they’re lookup, formula, or custom fields from any related object. Every column becomes filterable, unlike Salesforce dashboards.
Step 5. Build dynamic dashboards with pivot tables.
Create pivot tables and charts where every field responds to filter selections. Apply complex filter logic using AND/OR conditions that work across all field types, maintaining live data sync through scheduled refreshes.
Get the cross-object filtering Salesforce dashboards can’t provide
This approach gives you complete filtering capability across all Activity fields and related object data while maintaining automated data updates. Start building unrestricted Activity dashboards today.
