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
KA
Solved! Go to Solution.
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.
Hi @arundaka02,
Not sure what you need but I think this might be something that could give you guidance.
If this isn't helpful please provide us with the desired output.
Thanks, @ImadZidan
When I removed email address and grouped by the skill, the count was displaying as expected.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |