)
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.”
Yes, row-level formulas containing merged values can be disaggregated for chart visualization, but this requires moving beyond Salesforce’s native limitations.
Here’s how to break apart formula-generated concatenated results and create component-level visualizations that update automatically.
Import formula fields and apply advanced disaggregation techniques
Coefficient imports your Salesforce data, including formula fields, into Google Sheets where you can apply text parsing, dynamic arrays, and conditional extraction to disaggregate merged values.
How to make it work
Step 1. Import Salesforce data with merged formula fields.
Connect Coefficient to pull in your Salesforce records that contain formula fields with concatenated results. This includes any calculated fields that combine multiple values into single strings.
Step 2. Apply text parsing functions to extract components.
Use,, andfunctions to extract individual components from formula-generated merged values. For pattern-based extraction, tryto capture all components regardless of delimiter.
Step 3. Implement dynamic array processing.
Useto apply disaggregation across entire columns efficiently. This processes all your formula field results at once instead of row by row.
Step 4. Add conditional extraction for specific patterns.
Combineandfunctions to identify and extract specific components based on patterns within your formula field results. This is useful when different rows contain different types of merged data.
Step 5. Enable automatic processing of new records.
Turn on Formula Auto Fill Down so your disaggregation formulas automatically process new records during scheduled refreshes. Set up Coefficient’s refresh schedule to keep your component analysis current.
Create dynamic visualizations from formula field components
This approach transforms static formula field outputs into chartable individual components that stay current with your Salesforce changes. Try Coefficient to unlock component-level analysis from your merged formula field data.
