Domo Percent of a Ratio?

Hello All,
I have a simple horizontal bar displaying a ratio by reporting categories.
For example,
Category A - 27.9%
Category B - 26.8%
Category C - 25%
etc.
I would like to add a series that colors those bars by a sub category, but without losing the above.
Right now I seem to get the % totals of the sub categories stacked on top of one another, which is throwing things off.
Any ideas?
Thanks,
Jason
Comments
-
Hi @user007486
Have you tried adding in your series but then setting your data label setting to be the Percent of Category (%_PERCENT_OF_CATEGORY ) instead of the series?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I have tried that however to no avail.
The bars themselves seem to keep the same proportions, however when I add the series, the x-axis shifts and is messed up. I guess the solution would be to force the x-axis to maintain scale off of the original ratio. If that makes sense?
0 -
To provider some more detail on the formula driving the original ratio i'm doing the following:
SUM(Numerator) / SUM(Denominator)
Could there be a way to perhaps PARTITION BY in the Beast Mode?
0 -
You could use a window function within a beast mode (talk with your CSM to get it turned on if you don't have it yet, it's a simple feature switch).
SUM(SUM(`Numerator`)) OVER (PARTITION BY ...)
/
SUM(SUM(`Denominator`)) OVER (PARTITION BY ...)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 874 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive