Hi, I’m looking for ways to show a value’s percentage of a total in a table or pivot table.
Example:
| Loss Reason List | Qty | % of Total |
|---|---|---|
| Reason A | 10 | 25.0% |
| Reason B | 5 | 12.5% |
| Reason C | 15 | 37.5% |
| Reason D | 10 | 25.0% |
| Total | 40 | 100.0% |
Goals and Value:
- More professional report options. With executives reading dashboards, they want to understand a lot in a little bit of time and space. Percentages within tables give you the concise professionalism they want.
- More report features for dashboards. Tables are already apart of Hubspot and they would be enhanced greatly by the use of percentages within them.
- Save time keeping me in Hubspot. Currently, I need to export data to a spreadsheet and do myself. This should be a custom report option in Hubspot so I don’t have to waste time outside of Hubspot.
Help? If there’s a way to do this, and I don’t know it, please let me know! Pie charts can give you this distribution, but it’s unreasonable have a bunch of pie charts on a dashboard.
Who this Helps: All Sales, Marketing, Revenue teams that need to build impactful dashboards.