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 xaxis shifts and is messed up. I guess the solution would be to force the xaxis 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
 10.6K All Categories
 8 Connect
 918 Connectors
 250 Workbench
 477 Transform
 1.8K Magic ETL
 69 SQL DataFlows
 478 Datasets
 218 Visualize
 260 Beast Mode
 2.1K Charting
 12 Variables
 19 Automate
 356 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 249 Distribute
 65 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 191 Product Ideas
 1.2K Ideas Exchange
 11 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive