)
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.”
Making custom User fields appear in Salesforce dashboard filter options for activity reports is challenging due to platform limitations in how Activity objects expose cross-object fields in dashboard contexts.
Traditional solutions like formula fields or custom report types often fail to resolve the filter visibility issue. Here’s a reliable approach that works every time.
Get direct access to custom User fields for activity filtering using Coefficient
Coefficient offers a more reliable solution by importing Activity data with direct access to User relationship fields. You can include custom User fields using the format “Field Name (Relation)” and create filter controls that work consistently.
How to make it work
Step 1. Create a comprehensive Activity import with User fields.
Use Coefficient’s Salesforce connector to import from the Activity object. In the field selection, add custom User fields like “Sales_Region__c (Owner)”, “Territory__c (Owner)”, or “Department__c (Owner)” to access all the User data you need.
Step 2. Set up dynamic filter controls in your spreadsheet.
Create dropdown filters or input cells that reference your custom User fields directly. These filters can use complex AND/OR logic, date ranges, and multiple criteria simultaneously without any platform restrictions.
Step 3. Build interactive dashboards with pivot tables.
Use your spreadsheet’s pivot table functionality to create dashboards where all User custom fields are available for filtering. Add charts and visualizations that update automatically when you change filter criteria.
Step 4. Schedule automatic refreshes to maintain current data.
Set up daily, weekly, or hourly refresh schedules to keep your User field values current. Your filtering setup remains intact while the underlying data updates automatically from Salesforce.
Eliminate inconsistent filtering behavior
This approach provides consistent filtering behavior across all data types and eliminates the frustrating inconsistency where User custom fields work for Opportunity dashboard filters but not Activity dashboard filters. Try it for reliable access to all your User fields.
