)
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 treats concatenated field values like “Product A; Product B; Product C” as single text strings, making it impossible to count individual components in bar charts.
Here’s how to break apart those merged values and create charts that count each component separately.
Parse concatenated data in Google Sheets using Coefficient
Coefficient solves this by importing your Salesforce data into Google Sheets where you can use powerful text parsing functions. This lets you maintain your original concatenated fields while creating separate counts for each component.
How to make it work
Step 1. Import your concatenated data from Salesforce.
Connect Coefficient to your Salesforce report or object that contains the merged field values. The data will appear in Google Sheets with your concatenated fields intact.
Step 2. Create parsing formulas to separate the components.
In the column next to your concatenated data, useto separate values by semicolon. Addaround it liketo remove extra spaces. For a vertical list of all components, use.
Step 3. Enable Formula Auto Fill Down.
Turn on Coefficient’s Formula Auto Fill Down feature so your parsing formulas automatically apply to new records when your data refreshes. This keeps your component breakdown current without manual work.
Step 4. Build component-specific bar charts.
Create bar charts using the parsed individual components instead of the original concatenated field. Usefunctions to count how often each component appears across your dataset.
Step 5. Set up automatic refresh.
Schedule Coefficient to refresh your Salesforce data hourly, daily, or weekly. Your parsing formulas and charts will update automatically as new concatenated data comes in.
Start counting individual components today
This approach gives you both the readability of concatenated fields and the analytical power of individual component counting. Try Coefficient to transform your merged Salesforce data into actionable bar chart insights.
