Forum Discussion
Problem with binary variable
Hello I have a variable that is binary "1" and "0", I would like to obtain the percentage of the values equal to 1 but of the total, that is, the total would be the observations that are worth 1 and ...
Goog Night, man
Can you try this:
%_1 =
var total = count(YOURCOLUMN)
var count1 = calculate(count(YOURCOLUMN),YOURCOLUMN='1')
var result = count1/total
return result
Switch this measure do data % and bee happy!
Make this same process to "zero".