Good Afternoon Alteryx Community,
I have, what I believe is a simple question but I hit a road block and don't even know where to go next to achieve this. Here is my current data following the summarize & filter.
| Gender (M/F) | CountNonNull_Gender (M/F) |
| F | 52 |
| M | 56 |
I want this table to look more like this but don't know where to begin, Ive tried a few things with no luck:
| Gender (M/F) | Number (n=) | Percent (%) |
| Female | 52 | 48.14% |
| Male | 56 | 51.86 |
I want to change the F & M to female and male, and then add a third column doing the math to convert the numbers to percentages.
If you could please include a workspace, I would greatly appreciate it as it helps me continue to learn the program better and better each day.
Thank you in advance! You have been extremely helpful for my research,
Nick
