Get Count and Percentage of True and False

Hello All,

Apologies if this is a stupid question but I am new to designer and I am struggling to get my data in a certain pattern. If in excel it would have easy to do it but since I am getting used to alteryx I am trying to figure out . Below is sample of what I am trying to do. I am trying to count the TRUE, FALSE and their percentage and get it in a specific pattern.

Sample data:

Column A   Column B Column AB Results     Column C    Column D   Column CD Results    Column E    Column F    Column EF Results
      X             X                    TRUE                       Z                   X            FALSE                           Y               Y                  TRUE
       Y               Y                   TRUE                       Z                 Z              TRUE                           Y                 X                 FALSE
       X               X                    TRUE                      Z                   X              FALSE                           Y                Z                FALSE
      Y               Y                    TRUE                       Z                   Z               TRUE                            Y                X                  FALSE
     X               X                    TRUE                      Z                   X             FALSE                           Y               Y                 TRUE
       Y               Y                     TRUE                       Z                 Z               TRUE                             Y              X                  FALSE

Expected Output:

Status Column AB Results %Column AB Column CD Results %Column CD Column EF Results %Column EF

TRUE 6 100 3 50 2 33.33
FALSE 0 0 3 50 4 66.67

Total 6 100 6 100 6 100

Regards

Accepted answers

jdunkerley79

Agree - in which case you can do a transpose and cross tab style solution.

Sample attached doing it that way

Count and Percentage 2.yxmd

All comments

jdunkerley79

You will want to use the Summarize tool to produce the results. It will calculate the counts.

In order to produce a Total you will need a second Summarize tool and then Union it onto the first set.

You can then use a Formula tool to produce the percentages.

Hopefully, this is enough for you to work out how to build it but can make you a sample if you need.

skotian1289

Hi @jdunkerley79

Thanks for your response, it would be really helpful if you could show me a workflow sample using my sample data because that will help me understand better as to how alteryx tool works in this scenario.

Regards,

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703