ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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
binu_acs
21 - Polaris

@abrigante Are you looking something like below

binuacs_0-1647205082588.png

 

abrigante
5 - Atom

Yes, thank you!

Labels
Top Solution Authors