Forum Discussion
arimoldi
Resolver II
Resolver IIFrom Dataset to Matrix with Group By Columns
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
1 Reply
- lbendlin
Super User
The most efficient way is to use two separate matrix visuals.
