From Dataset to Matrix with Group By Columns

[arimoldi]

Hi,

I have a dataset like this:

year	unit	user	skill	result
2021	A	Apple	X	1
2021	A	Apple	Y	3
2021	A	Brown	X	2
2021	A	Brown	Y	3
2021	B	Nick	X	2
2021	B	Nick	Y	3
2021	B	Joe	X	3
2021	B	Joe	Y	3
2022	A	Apple	X	1
2022	A	Apple	Y	3
2022	A	Matt	X	1
2022	A	Matt	Y	2
2022	A	Lucky	X	1
2022	A	Lucky	Y	1
2022	C	Phil	X	2
2022	C	Phil	Y	3
2022	C	Hally	X	4
2022	C	Hally	Y	1

and I want to get a matrix like this:

				2021	2021	2021	2021	2022	2022	2022	2022
unit	count unit 2021	count unit 2022	skill	1	2	3	4	1	2	3	4
A	2	3	X	1	1			3
Y			2		1	1	1
B	2	0	X		1	1
Y			2
C	0	2	X						1		1
Y					1		1

Which is the most efficient and smart way to do it?

Thanks,

Andrea

[lbendlin]

The most efficient way is to use two separate matrix visuals.