How to show Group Total as # while Bars are shown as %?
I have a card right now using a Nested Bar Graph and I'm showing the series bars as % using the Data Label Settings as '%_PERCENT_OF_CATEGORY' but when I check the 'Group Totals' box it shows the total as a 100%, which is pretty useless to me because I want to see the actual count.
How can I do this? I thought about changing each series into it's own percentage calculation but that changes the entire scale into percentages and would also not show what for the Group Totals. Also, that is very tedious to make new beast modes for each series.
Is there a way to show Group Total as count and the series as %?
Comments
-
To my knowledge there isn't a way to do this as both the Group Total and Series values share the same data label format. I can see the value of this, but right now the only thing close would be to leave the Hover Text Settings to the value of the series so they can be moused over and show the summations instead of percentages.
If anyone else knows how to accomplish this, I'd love to hear how.
Sincerely,
Valiant_Ronin
0 -
Two alternatives you might consider:
1. Line + Nested Bar Visual
Use the Line as your count
The line can be a little confusing to your business user, as it usually implicates time. So you could also do
2. Symbol + Grouped Bar Visual
Use the Symbol as your count
Realize this too is imperfect given your intention bc they are no longer nested, but you could potentially do a second series on the Symbol value scale, one indicating count and the second indicating total size (the sum of your nest from #1)
Hope that make sense, and even moreso, hope it might spur you in the direction of what you need!
Domo Consultant
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive