HELP CENTER

HELP CENTER

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Dojo
- :
- Using Domo
- :
- Dataflows
- :
- Domo Percent of a Ratio?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-18-2020
08:34

11-18-2020
08:34

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-18-2020
11:39

11-18-2020
11:39

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 the heart icon**

**Did this solve your problem? Accept it as a solution!**

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-18-2020
12:38

11-18-2020
12:38

*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?*

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-18-2020
12:51

11-18-2020
12:51

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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-18-2020
12:55

11-18-2020
12:55

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 the heart icon**

**Did this solve your problem? Accept it as a solution!**

Announcements

Site will be down February 4-5th for maintenance.

Launch coming February 8th!