HubSpot Ideas

nellp

Display empty values in report charts

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

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

27 Replies
dwalczak
HubSpot Employee

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. 

BFenigsohn
Member

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.

MTurner4
Member

I just ran into this issue needing to display stages with 0 deals. This would be very helpful. 

trashangel_exe
Participant

Agreed, it is hard to visualize the sales pipeline without it!

SimonNeighbor
Member

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.

steph2829
Member

This would be an extremely helpful feature!

JSmyth
Member

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.

Nickjpeterson
Member

+1 please add this soon. It's needed for comparisons.

ADuarte4
Member

+1 please add this soon!!!

DiscoStu619
Member

Yes! Please add this for us also 🙂 

HunterAtTFV
Member

This would be awesome for our reporting needs, please add!

DStone1
Participant

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.

SQuintanilla
Member

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. 

MGan
HubSpot Employee
ecandgs
Member

We need this as well for custom reports!

TWilhelm
Member

+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 ?

MKahl
Member

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.

BTomjanovich
Participant

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.

Probley
Contributor

Related to this, it would also be helpful to suppress zeros sometimes as well. Suppress zero values in reporting (pivots & charts) 

Msyvrais
Key Advisor

++