Skip to main content
Question

Help me figure out why my chart is not charting 🤣

  • November 8, 2024
  • 0 replies
  • 78 views
Forum|alt.badge.img+9

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?

 

Forum|alt.badge.img+9
  • ChristineK
  • Author
  • Registered
  • November 8, 2024

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
Terms & ConditionsAccessibility statement