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
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有