# Summary Formulas in Datasets

**URL:** <https://community.hubspot.com/t/summary-formulas-in-datasets/90448>\
**Category:** Data Hub\
**Tags:** datasets\
**Created:** [September 26, 2023, 3:22am UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448 "2023-09-26T03:22:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![smcmillian](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/smcmillian/32/48165_2.png) [@smcmillian](https://community.hubspot.com/u/smcmillian)\
**Post date:** [September 26, 2023, 3:22am UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448/1 "2023-09-26T03:22:03Z")

</div>

**Introduction**

Hi, my name is Stephen, and I’m the product manager for datasets at HubSpot. I put together a series of videos to demonstrate how our new summary functions work to complement the [knowledgebase article](https://knowledge.hubspot.com/reports/create-and-use-summary-functions).

**Summary Functions**

Summary functions enable the ability to aggregate data across multiple rows in a dataset. This new functionality enables the computation of valuable business metrics including most rates and ratios.

 ![Screenshot 2023-09-25 at 4.03.47 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/9/f9b114cfe17fa439de475fcad36c6715f7f57a0a.png)

 ![Screenshot 2023-09-25 at 10.25.59 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/54f79dab279a03db0e49731de09fb0af1198f852.png)

**Explainer Videos**

1. [Introduction to Dataset Summary Measures](https://www.loom.com/share/198b8855fb104dd89ad97ff8041026a9?sid=6b7e6f45-755d-4c56-992e-c210e78bd2ab)
2. [Introduction to Dataset Fixed Summaries](https://www.loom.com/share/6161fc4657954f25a88029902fac8d75?sid=e146e877-6fe9-4c0e-80dd-33516a844936)
3. [Using Fixed Summaries to Power Up Conversion Rate Reporting](https://www.loom.com/share/d5808e34dfee47ebbd4fb8980c0fb996?sid=cbeb96ba-059d-4468-ac54-97a045ddbdd1)
4. [Using Fixed Summaries to Power Up Commission Based Reporting](https://www.loom.com/share/af482e72466547f28bcd852f05376dc3?sid=34359b8b-e992-4b51-8ee7-8d58fa1b42ad)

**Who Gets It?**

Operations Hub Enterprise Users

---

<div class="post-metadata">

**Author:** ![Sasmoer](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@Sasmoer](https://community.hubspot.com/u/Sasmoer)\
**Post date:** [September 27, 2023, 2:17pm UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448/2 "2023-09-27T14:17:39Z")

</div>

When can we expect this, I honestly cannot wait for this. So far I have been dumping csv files and then using python to contcat the dataframes

---

<div class="post-metadata">

**Author:** ![smcmillian](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/smcmillian/32/48165_2.png) [@smcmillian](https://community.hubspot.com/u/smcmillian)\
**Post date:** [September 27, 2023, 4:32pm UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448/3 "2023-09-27T16:32:47Z")

</div>

We released to a large group today and will be progressively rolling it out to all users. If you don’t see the new functions in your portal, please reach out to your account manager, and I can have you ungated!  
Best,  
SM

---

<div class="post-metadata">

**Author:** ![ErikHolmberg](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@ErikHolmberg](https://community.hubspot.com/u/ErikHolmberg)\
**Post date:** [October 3, 2024, 1:21pm UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448/4 "2024-10-03T13:21:11Z")

</div>

@smcmillian Is it possbile to use multiple IFs in a DISTINCT\_COUNT?

---

<div class="post-metadata">

**Author:** ![LOrhoj](https://avatars.discourse-cdn.com/v4/letter/l/b487fb/32.png) [@LOrhoj](https://community.hubspot.com/u/LOrhoj)\
**Post date:** [March 14, 2025, 11:09pm UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448/5 "2025-03-14T23:09:52Z")

</div>

@smcmillian Are those Looms still avaiable somewhere? 🙏 They seem to be deleted.

Best,  
Lars

---

<div class="post-metadata">

**Author:** ![HDamron](https://avatars.discourse-cdn.com/v4/letter/h/82dd89/32.png) [@HDamron](https://community.hubspot.com/u/HDamron)\
**Post date:** [January 26, 2026, 4:52pm UTC](https://community.hubspot.com/t/summary-formulas-in-datasets/90448/6 "2026-01-26T16:52:56Z")

</div>

Unfortunately, this isn’t helpful as all of the explainer videos linked are showing as deleted.