Exploring and Visualizing Data · Legacy self-service product
How to Create a Chart
Build visualizations from your data in just a few clicks
You're viewing documentation for the legacy Scoop self-service product. For the current product, see
What Is Scoop.
Scoop makes it easy to transform your data into compelling visualizations. Whether you want a simple bar chart or a complex time series, you can create charts in just a few clicks—no coding required.
Quick Start
| Step |
Action |
Result |
| 1 |
Click a metric column |
Instant chart appears |
| 2 |
Select chart type |
Visualization updates |
| 3 |
Add grouping dimension |
Data segmented |
| 4 |
Customize appearance |
Ready to share |
Step-by-Step Guide
Step 1: Open Your Dataset
Navigate to your dataset in Scoop. Ensure your data is loaded and visible.
| Access Method |
How |
| From Datasets page |
Click dataset name |
| From Explorer |
Select dataset from dropdown |
| From Canvas |
Click "Add Visualization" |
Step 2: Select Data to Visualize
Choose what to visualize using the Explorer panel:
| Data Type |
Role in Chart |
Examples |
| Dimensions (text/categories) |
X-axis labels, legend groups |
Region, Product, Status |
| Metrics (numbers) |
Y-axis values, bar heights |
Revenue, Count, Amount |
| Dates |
Time axis, trends |
Created Date, Close Date |
Quick selection:
- Click any column header to visualize it instantly
- Scoop auto-detects whether it's a dimension or metric
Step 3: Choose Chart Type
Click the Chart button in the toolbar to select your visualization:
| Chart Type |
Best For |
Example Use |
| Column Chart |
Comparing categories |
Revenue by Region |
| Bar Chart |
Horizontal comparison |
Top 10 Products |
| Line Chart |
Trends over time |
Monthly Revenue |
| Area Chart |
Cumulative trends |
Pipeline over time |
| Pie Chart |
Part-to-whole |
Revenue by Segment |
| Donut Chart |
Part-to-whole with center stat |
Deal Stage Distribution |
| Scatter Plot |
Correlations |
Price vs. Volume |
| KPI Card |
Single metric highlight |
Total Revenue |
| Table |
Detailed multi-metric |
Full data view |
Choosing the Right Chart
| Your Question |
Recommended Chart |
| "How do these categories compare?" |
Column/Bar |
| "What's the trend over time?" |
Line/Area |
| "What portion is each segment?" |
Pie/Donut |
| "Is there a correlation?" |
Scatter |
| "What's the key number?" |
KPI Card |
| "Show me the details" |
Table |
Dimensions (Grouping)
| Setting |
Purpose |
Example |
| Group By |
Split data into categories |
By Region |
| Stack By |
Add second grouping level |
Stack by Product |
| Color By |
Color segments differently |
Color by Status |
Metrics (Values)
| Setting |
Purpose |
Example |
| Primary Metric |
Main value displayed |
Sum of Revenue |
| Secondary Metric |
Additional axis (dual-axis) |
Count of Deals |
| Aggregation |
How to combine values |
Sum, Count, Average |
Filters
| Filter Type |
Effect |
| Dimension filter |
Include/exclude categories |
| Date range |
Limit time period |
| Metric filter |
Only values meeting criteria |
Date Settings
| Setting |
Options |
| Date Column |
Which date to analyze by |
| Period |
Day, Week, Month, Quarter, Year |
| Range |
Last week/month/year, custom |
| Period Type |
Rolling vs. Calendar |
Step 5: Customize Appearance
Colors
| Option |
Description |
| Theme colors |
Apply from visual theme |
| Custom colors |
Pick specific colors |
| Color by value |
Conditional coloring |
Labels and Legends
| Setting |
Options |
| Data labels |
Show values on chart |
| Legend position |
Top, bottom, left, right, none |
| Axis labels |
Customize axis text |
| Title |
Chart heading |
Sorting
| Option |
Effect |
| By value |
Largest to smallest (or reverse) |
| Alphabetical |
A-Z ordering |
| Custom |
Define your own order |
| Setting |
Options |
| Number format |
Currency, percentage, decimals |
| Axis range |
Auto or manual min/max |
| Grid lines |
Show or hide |
Interactive Features
Drill-Down
Click any chart element to drill into details:
| Click |
Result |
| Bar/slice |
Filter to that value |
| Time period |
Drill to finer granularity |
| Category |
See underlying records |
Hover over chart elements for:
- Exact values
- Percentage of total
- Additional metrics
Filtering
Click elements to filter other charts on the same canvas.
Common Chart Configurations
| Element |
Configuration |
| Chart Type |
Column |
| Metric |
Sum of Amount |
| Dimension |
Sales Rep |
| Sort |
By value, descending |
Trend Over Time
| Element |
Configuration |
| Chart Type |
Line |
| Metric |
Sum of Revenue |
| Date |
Monthly |
| Range |
Last 12 months |
Pipeline Distribution
| Element |
Configuration |
| Chart Type |
Donut |
| Metric |
Count of Deals |
| Dimension |
Stage |
| Sort |
By pipeline order |
Top Products
| Element |
Configuration |
| Chart Type |
Horizontal Bar |
| Metric |
Sum of Sales |
| Dimension |
Product |
| Filter |
Top 10 by value |
Tips for Great Charts
Keep It Simple
| Practice |
Why |
| One insight per chart |
Clear communication |
| Limit series to 5-7 |
Avoid visual clutter |
| Use clear labels |
Immediate understanding |
Choose Appropriate Scales
| Scenario |
Recommendation |
| General comparison |
Let Scoop auto-scale |
| Emphasize differences |
Set manual range |
| Multiple charts |
Use consistent scales |
Add Context
| Element |
Purpose |
| Descriptive title |
Explain the insight |
| Annotations |
Call out key points |
| Comparison lines |
Show targets/benchmarks |
Consider Your Audience
| Audience |
Recommendation |
| Executives |
High-level summaries, KPIs |
| Analysts |
Detailed, drill-down enabled |
| Operations |
Current status, actionable |
Troubleshooting
Chart Shows No Data
- Check filter settings
- Verify date range includes data
- Confirm dimension/metric selection
Wrong Values Displayed
- Check aggregation method (sum vs. count)
- Verify correct date column selected
- Review filter conditions
Chart Looks Crowded
- Add filters to reduce data
- Use "Top N" to limit categories
- Consider different chart type
Colors Don't Match
- Apply consistent theme
- Check color-by settings
- Verify legend mapping
What's Next?
Updated December 4, 2025