In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Counting cells with text

abrigante
5 - Atom

Hello, I am new to Alteryx and so far am really enjoying the program. I currently have a project for school where I need to interpret some data. I was wondering if there is a way I can easily count the number of values in a column (from excel) that aren't numerical. For example the column contains 3 different text values say "P, C, and N" I want to know how many of each P each C and each N and then compare them to the total for percentage evaluation. Is there a way to do that?

2 REPLIES 2
binuacs
21 - Polaris

@abrigante Are you looking something like below

binuacs_0-1647205082588.png

 

abrigante
5 - Atom

Yes, thank you!

Labels
Top Solution Authors