HubSpot Ideas

FMeyer

Reports: Stacked Column Chart (100%)

The Reports feature in Hubspot is great, but I have found a limitaton on stacked columns when wanting to generate a diagram for all values in relation to 100%. Basically I want to get stacked columns which are all the same height and the values are relative to their base value. In MS Excel this feature is already availible and in my opinion it shaves the process of figuring out in which relative context the next column is to the column im looking at. All this may look very cryptic at the first glace, this is why I've attached screenshots below to further elaborate on the idea.

 

    • Who (what type of role or team) is the feature for?
      This feature could help management to see at a glance which properties sales employees gave in relation to all companies of their ownership.

    • What is their goal?
      The goal is to have a quick comparison to a benchmark.

    • What value will this add?
      This feature could help management to get a quick overview over data but also help to compare two columns to each other.

    • Are there examples of other places or products who have this feature?
      In Excel there is a feature called "Stacked Column Chart (100%) which does exactly that.

    • Screenshots are attached:
      What is possible with Hubspot:
      hubspot_example.png

      What I was trying to achieve:
      excel_example.png

      The Feature in Excel:
      excel_feature.png

HubSpot Updates
Being Reviewed
December 05, 2023 12:07 PM

Hey all, this one is being actively worked on! Will be updating again soon.

12 Replies
danmoyle
Most Valuable Member | Elite Partner

I'm not data wizard, but this looks like a great option to have in reports for the analytical minds! 

Jnix284
Most Valuable Member | Diamond Partner

This is possible through the integration with Power BI, which has the same capabilities for charts as Excel, but so much more.

 

I would still love to see this feature native to HubSpot reporting, I think it would be a huge win for teams/customers who have used Excel to generate reports for numerous years and it breaks the leadership team's brain to see HubSpot reports. The struggle with buy-in on HubSpot reporting is real. I can't count the number of times I have had to export HubSpot data to create the Excel version of the exact same report, just so it would look like reports from other departments or past years...

niels_linbit
Participant

Same here - this should be a quick update. It bugs me how small things are buried here in the idea board... 

hannalofving
Contributor | Platinum Partner

This! Please ❤️

DDanssaert
Member

+1 We absolutely need this. It's impossible to evaluate the evolution of ratio's otherwise (e.g. the ratio of persona's or lifecycle stages over time). It seems indeed that this functionality already exists in the backend.

DDanssaert_0-1685611642778.png

 

GrumpyHippo
Member

Another upvote here seems like should be trivial.

Ruurd
Participant

Same here, I would like to see a trend in sources of deals over time. To do that I have week of deal creation on the x-axis and count of deals on the y-axis, broken down by source. This is already insightful, but in order to really see a trend, I would like to show the count of deals per source as a percentage of all deals created in a given week. Ergo: a 100% stacked bar chart (or 100% stakced area chart). 

Coopers
Member

Bumping, would love to see trends with 100% stacking

HBoyd
HubSpot Product Team

Hey all, this one is being actively worked on! Will be updating again soon.

danmoyle
Most Valuable Member | Elite Partner

Heck yeah! Thanks @HBoyd!

 

tmitch_sona
Participant

Commenting to get notified when this is available!

lorenposendek
Participant

+1 that this would be very beneficial to reporting.