user007486 Member

Great thanks for the responses guys. I'll give it a shot!

Thanks Mark. Its really helpful to see these type of styling videos.

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

@GrantSmith that's a nice idea. I'll see if I can make that work. I'm realizing now my math is going to be a little complicated since I'm trying to get the difference of two ratios. I think that needs to be done via ETL or Dataflow, correct? Anyway, thanks for the tip. I think that'll work.

Ok that seems to work. I guess I just need to make sure I get my beast mode calculations correct in order to avoid the display errors. thank you, sir!

Yeah that's a decent idea for a work around. Unfortunately the volume of data I'm working with I'm not sure I wanna cross join like that. I'll come up with a different work around. Thanks for the input.