)
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’s native dual-axis charts have significant limitations when displaying opportunity count versus amount by Account Executive. Poor scaling makes metrics unreadable, customization options are limited, and hover functionality doesn’t clearly show both metrics.
Here’s how to create sophisticated dual-axis visualizations with proper scaling and comprehensive data display that executives actually want to see.
Build professional dual-axis charts using Coefficient
Coefficient enables sophisticated dual-axis visualizations with proper scaling and comprehensive data display. Export your Salesforce opportunity data to Salesforce where you can create publication-quality charts that provide clear insights into both volume and value performance.
How to make it work
Step 1. Import optimized opportunity data.
Use Coefficient to import opportunities grouped by Account Executive, including Amount, Stage, Close Date, and quota information. Structure your data import to support both count and amount calculations with proper Account Executive attribution.
Step 2. Create dual-axis charts with intelligent scaling.
Build dual-axis charts in Google Sheets or Excel with custom axis scaling that makes both count and amount metrics readable. Configure left axis for opportunity count and right axis for total amounts with scaling that prevents one metric from overwhelming the other.
Step 3. Configure comprehensive hover displays.
Set up tooltips that clearly show opportunity count (left axis), total opportunity amount (right axis), average deal size (calculated), quota attainment percentage, and year-over-year growth. Make sure hover states distinguish between left and right axis values.
Step 4. Add professional formatting and benchmarks.
Apply consistent color schemes, axis labels, and legend formatting for executive-ready presentations. Add trend lines showing performance trajectories, benchmark lines for quota or team averages, and conditional formatting highlighting top performers.
Step 5. Enable dynamic filtering and drill-down.
Add Account Executive filters, territory selectors, and date range controls. Create drill-down capability to individual opportunity details and set up real-time refresh to maintain data accuracy.
Deliver executive-ready performance insights
This approach creates publication-quality dual-axis visualizations that provide clear insights into both volume and value performance by Account Executive, far exceeding Salesforce’s native capabilities. Start building the professional dashboards your executives expect to see.
