Hi everyone! I’ve just started using Quicksight so pardon me if the question is trivial.
I have a table made of several columns, each of which represent a variable (let’s call them “var1”, “var2”. etc.). The rows represent my entries which can just be 0 or 1 for each column.
I’d like to create a table that has on the rows the variables and as columns the count of 0s and 1s.
So, for example, I will have a row called “var1” and next to it I have the count of 0s under “var1” and then the count of 1s under “var1”.
How can I do this?
Thanks in advance