Chart with Multiple Stacked Columns from Multiple Fields

[Andrew_Ford2]

Hi AppSheet Community,

I’m trying to do something that I believe is simple but I’m having a lot of difficulty.

Context:
I have table sfr with columns sfr1, sfr2, sfr3, sfr4, sfr5, sfr1status, sfr2status, sfr3status, sfr4status, sfr5status. Every one of these fields is a Yes/No type.

Goal:
I am trying to create a chart to display this data. I would like the chart to show stacks of Yes/No counts for every one of these fields. So first a sfr1 column the count of sfr1 yes’s stacked with sfr1 no’s. Then sfr2 same thing, sfr 3, etc…

I’m not sure if I can just do this through the chart ui with the sfr table or if I need to create a new summary table or what. Any help or guidance would be much appreciated.

• Andrew