Sorry, let me re-summarize that in a way that maybe makes better sense hah. I wish Quickbase would allow post edits.
I want every label in my stacked-bar X series to ultimately = 100%. So, of this County (X label), here are how all of their outcomes unfolded.
I do have the data filtered, but my understanding of filters is that shouldn't affect what I'm doing - it's still applying my parameters to the series, as I've filtered it.
How this is powering:
Filtering by:
Qrew LegendI was able to do this using what are called summary variables and summary formulas in the set up of your chart.
In my testing my three outcomes were Win Loss Tie.
Make three helper field called like
[# Wins] with a formula of If([Outcome]= "Win", 1)
ditto for [# Loss] and [# Tie]
Make a stacked bar chart.
X axis is Category, leave Y blank for now.
Make a formula variable in the chart setup for Total Wins to total the helper field of [# Wins].
ditto for the other two.
Make a summary formula called Wins %. set as type formula percent w/ 0 decimals.
[# Wins (tot)] / ([# Wins (tot)] + [# Loss (tot)] + [# Tie (tot)]) * 100
ditto fo the other two.
now circle back to the top of the setup and set the Y axis as [Wins %].
Then hover beside that and green plus it to add a new Y axis values for [Loss %]. Hover again and add Tie %.
Run the report. There is a bug on old style versus new style reports. You will find that if you don't multiply by 100 than the Y axis is just zero and one. But if you flip the green switch at the top to the old style it shows a nice percentage on the side (if you don't multiply by 100) . So the work around that considering your users are going to land in the new style report is to multiple by 100.
