If a deal is not in the stage, reporting removes the deal stage from reporting visibility.
We were trying to create a report that would show all our stages whether or not a deal was loaded into that stage. What we found was the stage header disappears IF a deal in not listed in the stage.
There is no workaround. No filter that will force these headers onto the report. This would be a great addition to the reports feature. Visibility into all deal stages whether a deal is in that stage or not.
I've encountered this before with HubSpot reporting - if, for a given time period/filter, there are 0 deals/contacts/activities, etc. within the scope of the report, they are omitted from reporting.
I don't think there's any way of overcoming this in HubSpot at present - my recommendation would be to post something in the Ideas forum along the lines of "Option to include zero-valued data series in reports". If you explain your usage case, as above, I'm sure others would upvote your idea and this would bring it to the attention of the developers.
I had a brief look in Ideas before posting, and could only find this tangential post (same issue, different usage case):
I think a more generic "option to include zero-valued series" across ALL reports would likely get more upvotes and hence more developer attention. I've seen first-hand ideas from the community being incorporated into HubSpot, and have been involved in beta-testing and helping to improve the tools once they arrived.
I'm sorry there's no "here-and-now" solution (other than exporting your data e.g. to Excel!), but good luck!
Did my post help answer your query? Help the Community by marking it as a solution "The rest of my advice has no basis more reliable than my own meandering experience. I will dispense this experience... now!"
Since these reports are based in a deal stage, would be expected the deal not show if it's not in that stage.
My recommendation would be creating a custom funnel report and filter for "any" stage, so it will show every deal in each stage, and it will also count deals that passed to that deal stage, I believe this report will fit better to your goal.
Doesn't look like it works for what we're trying to support. That funnel reflects everything that has gone through the stage, verse, what's currently in that stage. Essentially we're trying to accomplish a pivot table to show what's currently in the stage, and if nothing is in that stage then it would show 0.
We do not currently have 369 deals in the "customer/s to be contacted" funnel.
I'm looking to find a way to build a report that shows every pipeline header and IF a deal is in that header it shows the count, IF no deals are in the header is shows 0.
In the above example, IF zero deals are in the stage, the stage header is removed from the report view. The reports below are the exact same, yet, you can see what is happening.
I've encountered this before with HubSpot reporting - if, for a given time period/filter, there are 0 deals/contacts/activities, etc. within the scope of the report, they are omitted from reporting.
I don't think there's any way of overcoming this in HubSpot at present - my recommendation would be to post something in the Ideas forum along the lines of "Option to include zero-valued data series in reports". If you explain your usage case, as above, I'm sure others would upvote your idea and this would bring it to the attention of the developers.
I had a brief look in Ideas before posting, and could only find this tangential post (same issue, different usage case):
I think a more generic "option to include zero-valued series" across ALL reports would likely get more upvotes and hence more developer attention. I've seen first-hand ideas from the community being incorporated into HubSpot, and have been involved in beta-testing and helping to improve the tools once they arrived.
I'm sorry there's no "here-and-now" solution (other than exporting your data e.g. to Excel!), but good luck!
Did my post help answer your query? Help the Community by marking it as a solution "The rest of my advice has no basis more reliable than my own meandering experience. I will dispense this experience... now!"