Overview
Reports transform datasets into visual insights through charts, tables, and metrics. Once you’ve selected a dataset (either standard or custom), you can configure how that data appears, what it measures, and how it’s filtered. Building a report involves:- Choosing your data source (dataset)
- Selecting a visualization type (chart, table, gauge, etc.)
- Mapping fields to chart elements (axes, metrics, dimensions)
- Applying filters to focus on specific data
- Configuring sorting and limits
- Saving and sharing your report
Step-by-Step Instructions
1. Starting a New Report
- Navigate to Reporting and select the Reports tab
- Click Create Report or the plus icon
- The report builder opens with three main panels
2. Selecting Your Dataset
- In the left panel, you’ll see: “1. Select dataset”
- The instructions read: “Choose a dataset to build reports with”
- Click the dataset dropdown and browse available options
- Select your dataset (e.g., Opportunities Value Analysis)
- Available fields from that dataset appear below the dropdown
“Changing the dataset will reset all configurations including chart type, field mappings, filters, sorting, and preview data. Are you sure you want to continue?“
3. Choosing a Chart Type
- In the middle panel, select your visualization type
- Available options include:
- Bar charts (vertical and horizontal)
- Line charts
- Pie charts
- Area charts
- Scatter plots
- Tables
- Gauges (single metric)
- And more
- Your choice depends on what you’re measuring (trends over time work well with lines, comparisons suit bars, etc.)
4. Mapping Fields to Your Chart
- After selecting a chart type, the system shows configuration options
- Drag fields from the left panel or use the configuration selectors
- For bar charts, you typically define:
- X-axis: What you’re measuring across (time periods, stages, rep names)
- Y-axis: The metric you’re tracking (revenue, count, average deal size)
- For pie charts, define:
- Dimension: How to slice the data
- Metric: What to measure
- Each chart type has specific configuration requirements
5. Applying Filters
- The preview panel on the right shows your chart as you build it
- Above the preview, you’ll find filter controls
- Click to add filters that narrow your data (e.g., “Only show opportunities owned by specific reps” or “Only include closed deals from last quarter”)
- Filters apply to the report each time it runs, keeping your view focused
6. Configuring Sort and Limit
- Control how many results appear using the limit setting
- Set sorting to display your most important data first
- For dimension fields (categories), the system may automatically add sorting
7. Previewing Your Report
- The right panel shows a live preview as you configure
- Make adjustments until the visualization clearly answers your question
- The preview updates automatically when you change settings
8. Saving Your Report
- Give your report a descriptive name (shown at the top of the page)
- Add a description explaining what the report shows and when to use it
- While editing, you’ll see: “Unsaved changes”
- Click Save report when ready
- The system creates your report and redirects you to the report view page
Troubleshooting/FAQ
Why can't I see certain fields in my dataset?
Why can't I see certain fields in my dataset?
The fields available depend on your selected dataset. If you need additional fields, you may need to create a custom dataset that includes them, or choose a different standard dataset.
My chart shows too much data. How do I narrow it down?
My chart shows too much data. How do I narrow it down?
Use filters to focus on specific records, and set a limit on the number of results. For example, show only the top 10 items instead of all results.
Can I use the same dataset for multiple reports?
Can I use the same dataset for multiple reports?
Absolutely. That’s one of the key benefits of datasets. Create one dataset and build as many different report views as you need.
What happens if I delete a dataset that has reports?
What happens if I delete a dataset that has reports?
Reports built on that dataset would break. The system prevents deletion of datasets that are in use.
Why does my chart look different after I change the chart type?
Why does my chart look different after I change the chart type?
Different chart types have different requirements. When you switch types, the system tries to preserve your configuration, but you may need to remap some fields to match the new chart’s structure.
Can I schedule reports to run automatically?
Can I schedule reports to run automatically?
Reports always reflect current data when viewed. For scheduled distribution, add reports to a dashboard and configure dashboard delivery settings.
How do I share a report with my team?
How do I share a report with my team?
Still have questions? Reach out to our support team here