Your HubSpot Dashboard Says "No Value"? Fix the Deals, Not the Report

A few weeks ago I was building a sales dashboard for a leadership team that wanted to see pipeline by business line. Simple enough. We built the chart, hit save, and the biggest bar on the screen was labeled "(No value)."

The CEO's first question was whether the report was broken. It wasn't. About a third of the open deals had never had a business line filled in. The dashboard was telling the truth. It just wasn't the truth anyone wanted to see.

Why this happens

"(No value)" is HubSpot's way of saying the property is blank. When it shows up in a big way, there are usually three reasons behind it:

• The property wasn't required. Reps fill in what HubSpot asks for. If the field is optional, it gets skipped when things are busy, which is always.
• The definition is fuzzy. In our case, reps weren't sure how to classify a deal sold through a partner to an end customer. When people aren't sure, they leave it blank rather than guess wrong.
• The property came later. It was added after a lot of deals already existed, or deals arrived through an import or integration that didn't map it.

The same thing happens with amount, close date and next activity date. Any report that groups or sums by a property is only as good as how consistently that property is filled in.

The fix

1. Define every value in one sentence. Write down what each option means and how to handle the edge cases, like partner deals. Put the definition in the property's description so reps see it right where they fill it in.
2. Make the gap visible. Build a simple report or saved view of open deals with the property blank, grouped by owner. Put it right on the dashboard next to the main chart. In our case, that one widget did more than any reminder email.
3. Require it at the right stage. In your pipeline settings, HubSpot lets you make properties required when a deal moves into a stage. Don't require everything on creation. Require business line once a deal is qualified, and amount and close date once there's a real opportunity.
4. Backfill in one sitting. Book 30 minutes with the team, open the "missing" view, and use bulk edit to fill in what's obvious. Handle the rest one by one. It goes faster than anyone expects.
5. Keep "(No value)" on the chart. It's tempting to filter it out so the dashboard looks clean. Don't. Leave it visible so everyone can watch it shrink, and so it can't quietly grow back.

Once the business line data was in place, the same dashboard answered the question leadership actually cared about: which part of the business was carrying the pipeline, and which wasn't.

How to tell if this is you

• "(No value)" is one of the top three bars on any pipeline chart
• Your forecast moves when someone updates a handful of deals in a cleanup sprint
• Reps ask what a property means, or answer it differently
• Leadership exports deals to a spreadsheet to "fix" the numbers before a meeting
• Deals reach late stages without an amount or close date

FAQ

What does "(No value)" mean in a HubSpot report?

It's the group of records where the property you're grouping by is blank. The report is working. The data is missing.

How do I make a deal property required in HubSpot?

In your pipeline settings, you can require properties when a deal moves into a specific stage. That works better than requiring everything when the deal is created.

Can I update a lot of HubSpot deals at once?

Yes. Filter a deals view down to the records you need, select them, and use bulk edit to set the property.

Should I hide "(No value)" on my dashboard?

No. Keep it visible so the team can see the gap shrink and notice if it grows back.

If you're not sure where your pipeline data is leaking, What the F*nnel?! is a quick, free way to check how well you can actually see your funnel. And if you'd rather talk it through, I'm always happy to hop on a call.