# Making calculations within reports or dashboards

**URL:** <https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [November 18, 2020, 8:46pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188 "2020-11-18T20:46:25Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Ivanjlares](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ivanjlares/32/102437_2.png) [@Ivanjlares](https://community.hubspot.com/u/Ivanjlares)\
**Post date:** [August 5, 2021, 7:11pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/21 "2021-08-05T19:11:09Z")

</div>

Huge differentiator! Love this idea and have been bumping up since!

---

<div class="post-metadata">

**Author:** ![SFyrand](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sfyrand/32/99412_2.png) [@SFyrand](https://community.hubspot.com/u/SFyrand)\
**Post date:** [August 10, 2021, 10:09am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/22 "2021-08-10T10:09:59Z")

</div>

Much needed!

---

<div class="post-metadata">

**Author:** ![tomwright1982](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tomwright1982/32/79644_2.png) [@tomwright1982](https://community.hubspot.com/u/tomwright1982)\
**Post date:** [August 17, 2021, 2:19am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/23 "2021-08-17T02:19:06Z")

</div>

Looks like Hubspot product team answers have been deleted from this thread. Can we get an update please? Thanks.

---

<div class="post-metadata">

**Author:** ![SMathiasen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/smathiasen/32/68963_2.png) [@SMathiasen](https://community.hubspot.com/u/SMathiasen)\
**Post date:** [September 2, 2021, 8:09am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/24 "2021-09-02T08:09:32Z")

</div>

Hope this could be realeased soon! We have all this data and it’s sad not to be able to make a report indside Hubspot

---

<div class="post-metadata">

**Author:** ![filozopp](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/filozopp/32/68963_2.png) [@filozopp](https://community.hubspot.com/u/filozopp)\
**Post date:** [September 15, 2021, 3:27pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/25 "2021-09-15T15:27:45Z")

</div>

Definitely! We need to get some ratio reports like Deals/Meetings or Meetings/Sales Activities, but there is no way to do this.

I can count it even in console, but we need this data in Hubspot for our management instantly in reports.

---

<div class="post-metadata">

**Author:** ![amandafann](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amandafann/32/29572_2.png) [@amandafann](https://community.hubspot.com/u/amandafann)\
**Post date:** [September 20, 2021, 7:42pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/26 "2021-09-20T19:42:19Z")

</div>

I would use this on many reports to calculate averages, conversion rates and percentages in the custom report builder! Looking forward to seeing this.

Additionally, it would be helpful if there were a place to input specific numbers that you’d like to use in your calculations. In my use case, I’d like to add benchmarks calcuated from outside sources, such as last year’s conversion rate, to use as a comparison to show progress so far this year.

---

<div class="post-metadata">

**Author:** ![Thomas\_Vanguard](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thomas_vanguard/32/100259_2.png) [@Thomas\_Vanguard](https://community.hubspot.com/u/Thomas_Vanguard)\
**Post date:** [September 21, 2021, 3:46am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/27 "2021-09-21T03:46:49Z")

</div>

This is becoming a critical feature.

In the absence of calculating properties in Line Items we can’t show special prices given to clients (Unit Price - Discount) because the Net Price automatically includes the Quantity. This feature would enable us to circumvent this by dividing the total by the Quantity to give us the Special Price.

---

<div class="post-metadata">

**Author:** ![MissTipsi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/misstipsi/32/44503_2.png) [@MissTipsi](https://community.hubspot.com/u/MissTipsi)\
**Post date:** [September 24, 2021, 1:33pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/28 "2021-09-24T13:33:19Z")

</div>

I mentioned it in another idea but seems relevant here. Funnel reports right now are really really poor.  
In a single report I want to be able to see  
# Leads from given source(s) created in a given timeframe  
# of those leads became MQL  
# of those leads became SQL  
# of those leads became Opportunity  
# of those leads became customer  
and stepwise conversion rates.  
I’d also like to be able to do this with Lead Status and not just Lifecycle stages. e.g # Leads that ever had Lead Status A who ever reached Lead Status B. Obviously being able to slice and dice by source, create dates, owners, form submissions etc.  
Then in relation to tables being able to display as a % instead of a value.

---

<div class="post-metadata">

**Author:** ![ELiao](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/eliao/32/9373_2.png) [@ELiao](https://community.hubspot.com/u/ELiao)\
**Post date:** [October 28, 2021, 9:18am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/29 "2021-10-28T09:18:00Z")

</div>

Please! really need this feature:) thank you!

---

<div class="post-metadata">

**Author:** ![fannykuhn](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fannykuhn/32/9373_2.png) [@fannykuhn](https://community.hubspot.com/u/fannykuhn)\
**Post date:** [November 1, 2021, 7:25am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/30 "2021-11-01T07:25:05Z")

</div>

Yes, I def agree. We want to, for example, calculate retention rates based on lost deals and closed deals and there is not a way to get this calculation to show in one graph (I had to make two and have to export/manually calculate the difference).

---

<div class="post-metadata">

**Author:** ![OLS-JPang](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ols-jpang/32/76793_2.png) [@OLS-JPang](https://community.hubspot.com/u/OLS-JPang)\
**Post date:** [November 4, 2021, 10:17pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/31 "2021-11-04T22:17:41Z")

</div>

Hi all, I think we’ve been heard.

> **[Upgrade Page UI](https://app.hubspot.com/pricing/3351797/upgrade/locked-nav-item?upgradeSource=datasets-locked-nav-item&redirected=true)**

Anyone else getting ideas about how they could use this?

😁

---

<div class="post-metadata">

**Author:** ![Thomas\_Vanguard](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thomas_vanguard/32/100259_2.png) [@Thomas\_Vanguard](https://community.hubspot.com/u/Thomas_Vanguard)\
**Post date:** [November 4, 2021, 10:27pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/32 "2021-11-04T22:27:53Z")

</div>

For those unable to view @OLS-JPang link: [Here’s the article.](https://community.hubspot.com/t5/9881-Operations-Hub/Presenting-to-you-Datasets/td-p/519300)

The article says it’s available on all Professional and Enterprise Hubs but checking in a client account it’s saying it’s unlocked through Operations Hub Enterprise.

I think it’s a bit rough that basic calculations aren’t available in Professional and Enterprise across all Hubs.

---

<div class="post-metadata">

**Author:** ![MissTipsi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/misstipsi/32/44503_2.png) [@MissTipsi](https://community.hubspot.com/u/MissTipsi)\
**Post date:** [November 5, 2021, 9:34am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/33 "2021-11-05T09:34:03Z")

</div>

Had it confirmed by CSM that Datasets are only part of Operations Hub  
Enterprise for the time being. The reference to Professional and Enterprise  
tier across hubs is in relation to Custom Report Builder access.  
So we will be waiting a while longer…which \*\*bleep\*\*. I agree that it should be available across professional tiers, could maybe stomach having to pay for the reporting add-on but not operations hub. Solely on this decision it would seem they are putting more emphasis on being able to define the datasets across teams etc, which I can see the rationale for, as opposed to on the basic functionality of calculated fields which should really be table stakes.

---

<div class="post-metadata">

**Author:** ![JulianTEC](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/juliantec/32/75439_2.png) [@JulianTEC](https://community.hubspot.com/u/JulianTEC)\
**Post date:** [November 5, 2021, 10:32am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/34 "2021-11-05T10:32:28Z")

</div>

Even something as simple as

Today’s date - Last Activity Date = Days Since Last Activity

---

<div class="post-metadata">

**Author:** ![Matthewk12](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/matthewk12/32/48852_2.png) [@Matthewk12](https://community.hubspot.com/u/Matthewk12)\
**Post date:** [November 16, 2021, 10:40pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/35 "2021-11-16T22:40:44Z")

</div>

Agreed, I really want this.

---

<div class="post-metadata">

**Author:** ![devHrfh](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@devHrfh](https://community.hubspot.com/u/devHrfh)\
**Post date:** [November 30, 2021, 4:14pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/36 "2021-11-30T16:14:43Z")

</div>

This is incredibly frustrating to not be able to do some simple date comparisons to filter or isolate data. Would love to see this get properly built out.

Thanks!

---

<div class="post-metadata">

**Author:** ![KJones53](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kjones53/32/104913_2.png) [@KJones53](https://community.hubspot.com/u/KJones53)\
**Post date:** [December 8, 2021, 11:35am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/37 "2021-12-08T11:35:09Z")

</div>

Agree this needs to be a feature in the Dashboard.

---

<div class="post-metadata">

**Author:** ![SvonAppen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/svonappen/32/59606_2.png) [@SvonAppen](https://community.hubspot.com/u/SvonAppen)\
**Post date:** [January 13, 2022, 9:05am UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/38 "2022-01-13T09:05:13Z")

</div>

Would be great to have that report calculations soon!

---

<div class="post-metadata">

**Author:** ![OGrushetska](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OGrushetska](https://community.hubspot.com/u/OGrushetska)\
**Post date:** [January 17, 2022, 2:45pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/39 "2022-01-17T14:45:58Z")

</div>

Agree, very much needed!🙂

---

<div class="post-metadata">

**Author:** ![lodonovan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lodonovan/32/45539_2.png) [@lodonovan](https://community.hubspot.com/u/lodonovan)\
**Post date:** [January 19, 2022, 7:05pm UTC](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188/40 "2022-01-19T19:05:32Z")

</div>

Agree this is much needed. Currently doing manually calculations but having this on my dashboard would be ideal.

[Previous page](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188.md?page=1)

[Next page](https://community.hubspot.com/t/making-calculations-within-reports-or-dashboards/28188.md?page=3)
