# Display empty values in report charts **URL:** \ **Category:** HubSpot Ideas\ **Tags:** reports\ **Created:** [August 19, 2021, 6:42am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541 "2021-08-19T06:42:08Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![nellp](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nellp/32/90652_2.png) [@nellp](https://community.hubspot.com/u/nellp)\ **Post date:** [August 19, 2021, 6:42am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/1 "2021-08-19T06:42:08Z")
A standard feature in most diagram/chart-creation is to “display empty value”, so I currently don’t understand why Hubspot reports does not have this functionality. For uniform and comparable charts across several roles (e.g. overview of tasks for several people, company lead status or deal stage per salesperson etc.) this would be very valuable. To clarify, I don’t mean the filter “[Value] \> _Is none/empty_”, but rather empty values on the x-axis of a chart like this one: ![image-Aug-13-2021-03-20-48-67-PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/f/9ff22e31a2b1474ad7b68c677f50f7e6da201c9f.png) Hubspot support confirms that this is currently not possible without creating a custom property for each point on the x-axis. This is an incredibly bulky workaround for something as simple as wanting to see (for example) all the lead status’ regardles of the number of contacts/companies with each status. It’s also practically impossible when the x-axis displays, for example, dates or periods of time. I would argue that statistically speaking, “none” is **as** significant as “less/more than none”. Here’s a side-by-side of two identical\* charts where the only difference is the ‘company owner’ property, where the value of a “show empty values” toggle would be incredibly useful to give a better overview at-a-glace, and avoid confusion. (\*) I’ve changed the colours on the chart on the right, but it’s worth noting that Hubspot does not assign consistent colours to the same value on different charts. “In progress” can be blue on one and purple on another, based on how many values the chart is displaying) ![Capture.JPG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/d/6dffd2cb0516900a640f5bf361e18bdd73e8e814.jpeg) ---
**Author:** ![dwalczak](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dwalczak/32/89812_2.png) [@dwalczak](https://community.hubspot.com/u/dwalczak)\ **Post date:** [October 15, 2021, 6:04pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/2 "2021-10-15T18:04:45Z")
This would be a great feature! Although there may not be data, sometimes companies have a need to view all properties on the x-axis or y-axis, despite having no values for that property. For example, if you’re reporting on the deal pipeline to view the count of deals in each stage, if Closed Lost has no deals, it could still be valuable to see the Closed Lost stage in the report view. For those working closely in HubSpot, they may know the different deal stages well, but if this report is being shared across the company, not everyone might be aware of the stages with no values. ---
**Author:** ![BFenigsohn](https://avatars.discourse-cdn.com/v4/letter/b/c0e974/32.png) [@BFenigsohn](https://community.hubspot.com/u/BFenigsohn)\ **Post date:** [January 24, 2022, 4:21pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/3 "2022-01-24T16:21:08Z")
I agree, it’s a needed feature. Without it the audience could assume there was a reporting error if we skipped deal stages, for example. I’d rather not have to explain the ambiguity. ---
**Author:** ![MTurner4](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@MTurner4](https://community.hubspot.com/u/MTurner4)\ **Post date:** [January 24, 2022, 8:03pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/4 "2022-01-24T20:03:15Z")
I just ran into this issue needing to display stages with 0 deals. This would be very helpful. ---
**Author:** ![Jo\_Flowers](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jo_flowers/32/99586_2.png) [@Jo\_Flowers](https://community.hubspot.com/u/Jo_Flowers)\ **Post date:** [February 28, 2022, 10:42pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/5 "2022-02-28T22:42:59Z")
Agreed, it is hard to visualize the sales pipeline without it! ---
**Author:** ![SimonNeighbor](https://avatars.discourse-cdn.com/v4/letter/s/d78d45/32.png) [@SimonNeighbor](https://community.hubspot.com/u/SimonNeighbor)\ **Post date:** [April 21, 2022, 10:24pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/6 "2022-04-21T22:24:11Z")
Just ran into this on some reporting that I am trying to run, it’s actually imparative that we be able to see that a stage in the pipeline is empty. Not having this is actively hurting my ability to correctly report my teams activities. I know this is probably low on the priority list, but it’s actually a little silly it’s not there in the first place. Pretty standard reporting stuff. ---
**Author:** ![steph2829](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/steph2829/32/44643_2.png) [@steph2829](https://community.hubspot.com/u/steph2829)\ **Post date:** [June 1, 2022, 7:24am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/7 "2022-06-01T07:24:48Z")
This would be an extremely helpful feature! ---
**Author:** ![JSmyth](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jsmyth/32/93635_2.png) [@JSmyth](https://community.hubspot.com/u/JSmyth)\ **Post date:** [June 22, 2022, 6:28am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/8 "2022-06-22T06:28:59Z")
Yes, it would be extremally beneficial from a reporting point of view to identify who has a 0 count against them for a particular activity i.e. calls. We use HubSpot to track and monitor interactions with customers and need to identify any gaps or misses, however HubSpot automatically excludes 0 counts which makes this difficult. ---
**Author:** ![Nickjpeterson](https://avatars.discourse-cdn.com/v4/letter/n/73ab20/32.png) [@Nickjpeterson](https://community.hubspot.com/u/Nickjpeterson)\ **Post date:** [July 14, 2022, 4:20pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/9 "2022-07-14T16:20:23Z")
+1 please add this soon. It’s needed for comparisons. ---
**Author:** ![ADuarte4](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@ADuarte4](https://community.hubspot.com/u/ADuarte4)\ **Post date:** [August 5, 2022, 9:54am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/10 "2022-08-05T09:54:24Z")
+1 please add this soon!!! ---
**Author:** ![DiscoStu619](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/discostu619/32/76463_2.png) [@DiscoStu619](https://community.hubspot.com/u/DiscoStu619)\ **Post date:** [August 23, 2022, 12:50am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/11 "2022-08-23T00:50:39Z")
Yes! Please add this for us also 🙂 ---
**Author:** ![HunterAtTFV](https://avatars.discourse-cdn.com/v4/letter/h/7cd45c/32.png) [@HunterAtTFV](https://community.hubspot.com/u/HunterAtTFV)\ **Post date:** [August 23, 2022, 12:57am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/12 "2022-08-23T00:57:51Z")
This would be awesome for our reporting needs, please add! ---
**Author:** ![DStone1](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@DStone1](https://community.hubspot.com/u/DStone1)\ **Post date:** [January 11, 2023, 8:40am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/13 "2023-01-11T08:40:34Z")
I was extremely surprised to find out that HubSpot cannot already do this. Showing null values is such a basic and common feature in every other reporting software I have used. This needs to be implemented ASAP. ---
**Author:** ![SQuintanilla](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SQuintanilla](https://community.hubspot.com/u/SQuintanilla)\ **Post date:** [January 24, 2023, 5:37pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/14 "2023-01-24T17:37:40Z")
I would also find it extremely helpful to show a graph chart where the category will show a zero value if no “count” exists. Otherwise, I don’t see the company name at all in the graph (in my particular case). I’m trying to track activity in key accounts. So when there is no activity, the account name does not show. Which severely diminishes the value of the chart/report. ---
**Author:** ![MGan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mgan/32/33919_2.png) [@MGan](https://community.hubspot.com/u/MGan)\ **Post date:** [February 9, 2023, 7:15am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/15 "2023-02-09T07:15:55Z")
Commenting on behalf of a customer! There are also similar ideas here: [https://community.hubspot.com/t5/HubSpot-Ideas/Reporting-Show-properties-in-legend-labels-with-zero-values-zero/idi-p/549925](https://community.hubspot.com/t5/HubSpot-Ideas/Reporting-Show-properties-in-legend-labels-with-zero-values-zero/idi-p/549925) (20 votes) [https://community.hubspot.com/t5/HubSpot-Ideas/Show-labels-with-no-value-in-report/idi-p/434130](https://community.hubspot.com/t5/HubSpot-Ideas/Show-labels-with-no-value-in-report/idi-p/434130) (14 votes) ---
**Author:** ![ecandgs](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ecandgs](https://community.hubspot.com/u/ecandgs)\ **Post date:** [July 11, 2023, 7:53pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/16 "2023-07-11T19:53:28Z")
We need this as well for custom reports! ---
**Author:** ![TWilhelm](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/twilhelm/32/68963_2.png) [@TWilhelm](https://community.hubspot.com/u/TWilhelm)\ **Post date:** [September 10, 2023, 9:08pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/17 "2023-09-10T21:08:41Z")
+1 for this feature, I would love to understand why it has not been done already. Is there someone from Hubspot product team that could share his thoughts in this thread ? ---
**Author:** ![MKahl](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@MKahl](https://community.hubspot.com/u/MKahl)\ **Post date:** [October 22, 2023, 1:50am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/18 "2023-10-22T01:50:52Z")
I can’t believe this hasn’t been added yet. Our company is new to Hubspot and heard many amazing things about the reports you can pull, but so far we’ve had several issues trying to set up reports that work for us. This is a BIG issue. I’m trying to pull a report to show activities for all users…to help identify which team members are/are not using the new system. The report only shows people who have activity, so someone with no activity just doesn’t show up on the list, making it hard for us to identify those not using the system. ---
**Author:** ![BTomjanovich](https://avatars.discourse-cdn.com/v4/letter/b/ecc23a/32.png) [@BTomjanovich](https://community.hubspot.com/u/BTomjanovich)\ **Post date:** [November 2, 2023, 7:50pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/19 "2023-11-02T19:50:30Z")
EXTREMELY frustrating that this is not a current feature - sometimes a “zero value” is the most important in a chart like this and the fact that we can’t even pull that is crazy to me. ---
**Author:** ![Probley](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/probley/32/103413_2.png) [@Probley](https://community.hubspot.com/u/Probley)\ **Post date:** [November 16, 2023, 6:15pm UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/20 "2023-11-16T18:15:07Z")
Related to this, it would also be helpful to suppress zeros sometimes as well. [Suppress zero values in reporting (pivots & charts)](https://community.hubspot.com/t5/Reporting-Analytics/Suppress-zero-values-in-reporting-pivots-amp-charts/m-p/880531#M5562) [Next page](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541.md?page=2)