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:
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)
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.
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.
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.
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.
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.
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.
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.
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.