)
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.”
Dashboard filters for activity reports in Salesforce only show lookup fields because the Activity object has restricted cross-object field reference capabilities in dashboard contexts, unlike other objects that expose custom fields more freely.
This limitation stems from how Salesforce handles field relationships for Tasks and Events. Here’s how to work around these restrictions and access all the fields you need.
Access all activity fields with unlimited filtering using Coefficient
Coefficient bypasses these native dashboard filter limitations entirely by pulling Activity data directly with full User object fields included. You can apply unlimited filtering logic and build custom dashboards that work consistently across all data types.
How to make it work
Step 1. Connect to Salesforce and select your Activity data.
Open Coefficient in your spreadsheet and choose “From Objects & Fields” to pull Activity records. Select the Task or Event object and include any User custom fields using the relationship lookup format like “Sales_Region__c (Owner)” or “Territory__c (Owner)”.
Step 2. Set up dynamic filtering controls.
Create filter controls in your spreadsheet that reference these custom User fields directly. You can use AND/OR logic, point filters to cell values, and combine multiple filter conditions without any of the restrictions you face in native Salesforce dashboards.
Step 3. Build interactive dashboards with pivot tables and charts.
Use your spreadsheet’s pivot table functionality to create dashboards with full filtering capabilities across all imported fields. Add charts, conditional formatting, and summary calculations that update automatically when you change filter criteria.
Step 4. Schedule automatic data refreshes.
Set up hourly, daily, or weekly refresh schedules to keep your dashboard current. Your custom filtering setup remains intact while the underlying data updates automatically from Salesforce.
Get consistent field access across all your reports
This approach eliminates the inconsistent behavior between Activity and Opportunity report filtering while providing more flexible dashboard capabilities than native Salesforce dashboards. Start building better activity reports today.
