Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

SOLVED

Count Nulls by Grouping columns

8 - Asteroid

I have a data that looks like this

 

groupvar1var2var3
1  0.9
10.5  
1   
2 0.70.5
2   
20.8  
3   
3   
3 11

 

I need to count the number of nulls under each group and publish it in below structure

 

 nulls_group1nulls_group2nulls_group3
var1223
var2322
var3222

 

How can i do this in Alteryx?

Highlighted
Alteryx Certified Partner

Hey @GaRaGe

 

This should give you the answer you are looking for:

 

CountWithNulls.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi.

 

Transpose your dataset, the key field will be you group field, and your data fields will be your variables.

You can then do a summerize, and count null option, grouping by both your new [name] field generated by the transpose (this is just the variable field names) and also your group field.

You can then crosstab your data back into your desired output format.

 

Attached is an example.

 

Ben

Labels