Recommand · July 22, 2021 0

Count occurrence and percentage of this occurrence

I have a table ("gsheet.table") with one column ("column") containing "Yes" or "No".

I’d like a graph with two columns out of this table.

One counts the total number of occurrence of "Yes".
And the second shows the percentage of "Yes" compared to the total number of rows in the column.

I’m very new to SQL and having a hard time doing this. Could you help me please?