Domo Percent of a Ratio?

[user007486]

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

[GrantSmith]

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?

[user007486]

@GrantSmith 

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?

[user007486]

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?

[GrantSmith]

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 ...)