Forum Discussion

ChristineKirk's avatar
ChristineKirk
Qrew Cadet
14 days ago

Help me figure out why my chart is not charting 🤣

Hi all,

I'm trying to do a bar chart where my values across the X label always = 100% of the specific label. I'm not sure what I'm doing wrong on the back end, but I am not sure WHAT it's calculating here.... it seems like the bar chart may be showing how often each county used my program (but that doesn't make sense either -- because in that case, left to right the total would be 100%, and that's not the case either). I want it to basically measure that, WHEN a county used my program, these are the three outcomes by percentage -- and each county's total should = 100%

What might I be doing wrong?

 

reports
  • ChristineKirk's avatar
    ChristineKirk
    Qrew Cadet
    14 days ago

    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:

    • X Label = Counties
    • Y Label = Calls to my program
    • Series = The outcomes of the calls I'm trying to display, which added up = 100% of Y

    Filtering by:

    • Calls that weren't the type that I want to see, by date, and by call type not being the right type
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      13 days ago

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