Domo Percent of a Ratio?

user007486
user007486
in Magic ETL

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

  • GrantSmith
    GrantSmith Coach

    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!**
  • user007486
    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
    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
    GrantSmith Coach

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

Categories