How to Create and Use Summary Functions in HubSpot Datasets?

When reporting in HubSpot feels clunky or duplicative, it’s often because you’re not working with well-structured data. Maybe you’re exporting deals every week, manually aggregating pipeline metrics in Excel, or piecing together reports that don’t match across departments. That’s where HubSpot datasets come in, and more specifically, how you use summary functions to streamline your entire reporting process.

Summary functions unlock the potential of datasets by letting you calculate running totals, averages, counts, and more, directly inside HubSpot. No spreadsheets. No guesswork. Just accurate, shared metrics you can trust across marketing, sales, and RevOps teams.

This guide walks you through what summary functions are, how to use them, and how to avoid common missteps, along with examples to help you apply these features in your own HubSpot portal.

Calculate Custom Metrics Using HubSpot Dataset Summary Functions

Inside HubSpot, a dataset functions like a tailored data source for your custom reports. You’ll find it in Operations Hub (Professional or Enterprise tiers) under Reports > Datasets. Building a dataset means joining data across objects, like Deals, Contacts, and Tickets, and shaping that data before it ever hits your dashboards.

Summary functions play a vital role in this shaping process. You define them through a calculated column, choosing to operate either row-by-row or at a grouped (summary) level. 

Specifically, these functions allow you to calculate:

• SUM: Total across a numeric field
• COUNT: Number of records in a group
• AVERAGE: Mean value of a numeric field
• MIN/MAX: Smallest or largest value in a field

These calculations run within the dataset layer, before you build a report, so you can reuse the output across multiple charts, tables, and dashboards.

In the dataset editor, click “Add Calculation” and select the aggregation (summary) type. You’ll then define which dimensions to group by and choose the metrics to summarize. By working at the dataset level, you’re improving both performance and consistency across all your reports.

Because datasets pull from HubSpot’s real-time CRM, your fields come with full context. For example, you can link a Deal to its Owner and Company, and summarize revenue by any of those attributes.

How It Works Under the Hood

Think of summary functions as your shortcut to clean, high-value metrics. Instead of pulling raw records into a report and aggregating them there, you apply business logic once, directly in your dataset.

Here’s how the process works:

• Input fields: These are numeric or date-based properties from CRM objects (e.g., Deal Amount, Ticket Time to Close).

• Grouping dimensions: The level you want to segment by, like Pipeline, Owner, or Lifecycle Stage.

• Aggregation function: Choose the type of metric you want (SUM, AVERAGE, COUNT, MIN, MAX).

• Output field: A new column that stores the calculated result for each group.

Say you group by Deal Owner and apply a SUM to the Amount field. HubSpot will calculate total revenue per owner and output one row for each rep, simplifying how your dashboard reads and functions.

You can also customize:

• Whether non-grouped fields stick around
• Multiple groupings (e.g., Owner and Region)
• Filters before calculation (to focus only on Closed Won deals, for instance)
• Output formatting (currency, percentage, plain number)

Since the summary function runs before any visualization, your reports don’t have to do the heavy lifting. That means faster load times and a shared source of truth for every team member building reports from the same dataset.

Main Uses Inside HubSpot

Aggregate Revenue or Pipeline Metrics

If you’re managing a sales team or overseeing revenue operations, tracking total pipeline or closed revenue by deal owner, stage, or region is essential. Summary functions take manual math and turn it into plug-and-play dashboards.

Example: Create a dataset using Deals as the base object and include Owner as a related field. Add a calculation using SUM(Amount) grouped by Owner. You’ll get one row per salesperson with total revenue, which you can drop into a leaderboard-style chart to rank performance.

This replaces weekly spreadsheet exports and eliminates the need for manual pivot tables or error-prone filters.

Average Time to Resolution

For service teams, customer experience lives in the details, like how long it takes to close a ticket or how quickly support responds. Measuring these SLA metrics through summary functions makes dashboards more actionable.

Example: Build a dataset with Tickets as the primary object. Add an AVERAGE(Time to Close) calculation grouped by Team. The result shows how each team performs in terms of resolution speed. Layer in a secondary grouping by ticket category to analyze workload distribution and spot any service bottlenecks immediately.

Marketing Campaign Results by Source

Your marketing team needs more than just open rates or clicks. With datasets, you can align contact engagement, campaign activity, and revenue in a single calculation.

Example: Start with a dataset combining Contacts, Campaigns, and Deals. Use COUNT(Contact ID) grouped by Campaign Name to measure engagement. Then layer in a SUM(Deal Amount) to see the revenue your campaigns influenced. Now, you’ve got visibility into full-funnel performance without cobbling together multiple reports.

These calculations fuel trustworthy marketing dashboards that show what’s working and where to invest.

RevOps Efficiency Ratios

RevOps teams often combine metrics from across roles or departments to identify long-term trends or conversion efficiency. Summary functions let you track these metrics with clarity and consistency.

Example:

With a Deals + Owners dataset, calculate:

• SUM(Deal Amount) per owner – total revenue
• COUNT(Deal ID) per owner – deal volume
• Then, use a custom formula: revenue ÷ deal count = average deal size

You’ve just created a reusable metric for comparing rep performance and pipeline efficiency, without having to build and rebuild complex spreadsheets.

Common Setup Errors and Wrong Assumptions

Avoiding the most frequent missteps will save you time and sanity.

• Wrong data type: Summary functions only work on numeric or timestamp fields. Trying to calculate a SUM on a dropdown or text field won’t work. Check your field type, and for timestamps, convert to numeric where needed.
• Confusing logic with multiple groupings: Too many grouping layers can muddle your result. Start with one dimension (like Owner or Region), and only layer on others if the use case calls for it.
• Filtering after summarizing: Don’t wait until the final report to filter. Filtering after the summary step can lead to inaccurate totals. Always apply necessary filters inside the dataset before your calculation.
• Assuming real-time updates: Datasets capture a snapshot of your CRM. If data changes, like a new deal closing, you’ll need to refresh the dataset to update any summary fields.

Step-by-Step Setup or Use Guide

Using summary functions in HubSpot is a straightforward process, once you know where to look. Here’s how to get started:

1. Log in to HubSpot and navigate to Reports > Datasets
2. Click Create Dataset and select your primary object (like Deals)
3. Add related objects if needed (such as Owners or Contacts)
4. Choose the fields you plan to use: Deal Amount, Close Date, Stage, etc.
5. In the editor, click Add Calculation and select Aggregate Calculation
6. Choose your aggregation type (SUM, COUNT, AVERAGE, etc.)
7. Pick the field you want to summarize (e.g., Amount)
8. Define the grouping dimension (e.g., Owner)
9. Give your field a clear name like “Total Revenue by Owner.”
10. Apply filters in-dataset, like Stage = Closed Won or Date = This Quarter
11. Save and run the dataset. Confirm that the grouped calculation shows correct outputs
12. Use this dataset as your reporting source. Your new summary fields will appear as standard metrics, ready to graph or table

Once done, you can use your dataset to feed any custom report and maintain scalable insights without reinventing the wheel.

Measuring Results in HubSpot

To make sure your new summary functions deliver what you expect, build a pattern of validation and performance tracking.

Here’s a practical QA checklist:

• Cross-check key summary values with a manual export or list view
• Validate consistency across dashboards using the same dataset
• Schedule dataset refreshes (daily or weekly) based on CRM activity
• Monitor load times, summary data loads faster than raw records
• Create a simple internal validation report that spot-checks top metrics monthly

This helps avoid data mismatches and reinforces one consistent reporting logic across platforms and departments.

Short Example That Ties It Together

You work in RevOps at a software company with five pipelines and a dozen reps. Leadership wants clean reporting on closed-won revenue by rep and average deal size, updated weekly.

You create a dataset based on Deals and relate it to Owners. You apply two filters: Stage = Closed Won and Close Date = This Quarter. Then, you add:

• SUM(Amount) by Owner to measure total revenue
• AVERAGE(Amount) by Owner to calculate the average deal size

Using this one dataset, you build a performance dashboard that includes a leaderboard for revenue and a table for deal efficiency. When your reps close new deals, you refresh the dataset, and the reports update on their own, no export needed, no spreadsheet wrangling.

How INSIDEA Helps

Getting summary functions right is more than just knowing where the button lives. You need clear metrics, reliable data sources, and good cross-team alignment. That’s exactly where INSIDEA supports you.

Here’s how we help:

• HubSpot onboarding: Launch your datasets correctly from day one
• Ongoing management: Keep your CRM structured and your data clean
• Automation workflows: Feed the right data into reports with precision
• Strategic reporting: Align dashboards with your core sales, marketing, and service objectives

If better reporting accuracy and dataset clarity are priorities, our HubSpot experts can help you take the next step. Book a call to start the conversation or check out INSIDEA’s HubSpot consulting services.