We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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