Count Nulls by Grouping columns

GaRaGe

I have a data that looks like this

group	var1	var2	var3
1			0.9
1	0.5
1
2		0.7	0.5
2
2	0.8
3
3
3		1	1

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

	nulls_group1	nulls_group2	nulls_group3
var1	2	2	3
var2	3	2	2
var3	2	2	2

How can i do this in Alteryx?

LordNeilLord

Hey @GaRaGe

This should give you the answer you are looking for:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

CountWithNulls.yxmd