Calculate true false for pie chart and percentage

[andy47255]

I'm new and am probably searching for this incorrectly, if someone can point me in the right direction it would be much appreciated.

I made an appsheet with 60 questions. I'd like to display how many are answered true and how many are false in a pie chart. I'm guessing there is an expression I need to create or virtual column with a count?

I'd also like to see a score or percentage based on that result, for example: If out of 60 total questions, 42 were true then the score would be 70%.

[Joseph_Seddik]

The Chart view would do that without additional calculations.