)
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.”
Adding static reference lines to weekly sequence enrollment charts without relying on goal settings is ideal when HubSpot’s native charting has limited reference line capabilities and forces you through the problematic monthly goal system.
You’ll learn how to create true static reference lines through spreadsheet-based visualization that gives you complete control over positioning and formatting.
Create true static reference lines using Coefficient
HubSpot’s goal-dependent system can’t deliver clean, consistent static reference lines for weekly reporting periods. Coefficient enables you to build static reference lines in spreadsheets where you have full control over values and positioning.
How to make it work
Step 1. Import sequence enrollment data with weekly grouping.
Pull sequence enrollment data from HubSpot or HubSpot using Coefficient with weekly date grouping. This gives you the foundation for proper weekly reference lines.
Step 2. Create a separate reference line column.
Add a data column with your static value (like 20 companies) repeated for each weekly period. This becomes your horizontal reference that doesn’t depend on platform goal configurations.
Step 3. Set up charts with dual data series.
Use spreadsheet charting to display actual enrollments as your primary data series (bars or line) and your static reference value as a secondary series formatted as a straight horizontal line with distinct color and style.
Step 4. Add advanced static reference options.
Create multiple reference lines for minimum, target, and stretch goals. Add conditional reference lines that change based on seasonality, rolling average reference lines from historical performance, or percentile-based references like 75th percentile performance.
Step 5. Enable historical reference tracking.
Use Coefficient’s snapshot feature to preserve historical reference line performance over time. Set up contextual annotations and labels that explain what each reference line represents.
Get the clean reference lines you need
This method provides complete control over reference line values and positioning without dependency on platform goal configuration limitations. Start building your static reference line charts today.
