This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
A first solution, not very elegant IMO, is casting every 30 columns to Bytes through the Formula tool. However, it takes forever to do so because it is not possible to copy paste a formula inside the formula tool (another thing I cannot get my head around).
Another solution is to use the summarize tool via the group by then sum method, but I could not get it to work since in the screenshot of that page the bool column is already a byte but mine is a bool.
Then there is the other solution with the frequency table and I did not try it because at this point I do not want the frequencies I want only to count the number of True values.
As an example, here is a little test table of 2 columns and 5 rows:
col1 has 3 True and col2 has 2 True, that what I want to get.