Hi everyone In extension to my previous (now solved) post surrounding a skills matrix style data set, I want to perform a COUNTIF related function on the following data set and in particular the 'Skill Score' column: Email address Skill (new column name)Skill Score (new column name)example1.example1@xyz.comSkill 12example1.example1@xyz.comSkill 21example1.example1@xyz.comSkill 33example1.example1@xyz.comSkill 43example1.example1@xyz.comSkill 53example2.example2@xyz.com Skill 10example2.example2@xyz.comSkill 23example2.example2@xyz.comSkill 33example2.example2@xyz.comSkill 41example2.example2@xyz.comSkill 50 A score of 3 has a higher weight than a 1 or 2, so I want to count the number of each response (0, 1, 2 and 3) as I want to visualise the spread of the respondent's skill level. In Excel I would typically write a COUNTIF formula at the foot of the data set and count the responses . Which is the best way I can do this in Alteryx? I've been playing around with the Summarize tool and the COUNIF does not feature - should I be using the Formula tool? Thanks KA

CountIF related problem

Hi everyone

In extension to my previous (now solved) post surrounding a skills matrix style data set, I want to perform a COUNTIF related function on the following data set and in particular the 'Skill Score' column:

Email address	Skill (new column name)	Skill Score (new column name)
example1.example1@xyz.com	Skill 1	2
example1.example1@xyz.com	Skill 2	1
example1.example1@xyz.com	Skill 3	3
example1.example1@xyz.com	Skill 4	3
example1.example1@xyz.com	Skill 5	3
example2.example2@xyz.com	Skill 1	0
example2.example2@xyz.com	Skill 2	3
example2.example2@xyz.com	Skill 3	3
example2.example2@xyz.com	Skill 4	1
example2.example2@xyz.com	Skill 5	0

A score of 3 has a higher weight than a 1 or 2, so I want to count the number of each response (0, 1, 2 and 3) as I want to visualise the spread of the respondent's skill level.

In Excel I would typically write a COUNTIF formula at the foot of the data set and count the responses .

Which is the best way I can do this in Alteryx? I've been playing around with the Summarize tool and the COUNIF does not feature - should I be using the Formula tool?

Thanks

Help

Data Investigation

Accepted answers

ImadZidan

Hello @arundaka02 ,

May be this will also help.

ScoreGroupCount.yxmd

All comments

markcurry

Hi @arundaka02 , to count the different skill scores for each email address, use the Summarize tool. Group By Email Address, also Group By Skill Score, and Count Skill Score. Hopefully that gives you want you're looking for.