Forum Discussion
Solved
Matrix with multiple culomns by multiple colomns
Hello,
I think i'm trying to do something simple but I cannot find how.
I have data looking like this:
ID | Good1 | Good2 | Good3 | Bad1 | Bad2 | Bad3 |
| 1 | x | x | x | |||
| 2 | x | x | x | |||
| 3 | x | x | x | |||
| 4 | x | x | ||||
| 5 | x | x | x | |||
| 6 | x | x | x | |||
| 7 | x | x | ||||
| 8 | x | x | ||||
| 9 | x | x |
And I want to show it like that
| Good1 | Good2 | Good3 | |
| Bad1 | 1 | 1 | 1 |
| Bad2 | 0 | 1 | 3 |
| Bad3 | 2 | 2 | 1 |
Basicly, I want a CountIfs. How many poeple are Bad1 and Good1.
The complexity seams to come by the fact that they can have multiple Good and Bad.
Thanks in advance 🙂
trying to do something simpleahaha. Good one. None of this is simple.
Here's a version that works but at a high cost - an atrocious data model
see attached.
Here is a more accurate version that also considers the non-matches.
3 Replies
trying to do something simpleahaha. Good one. None of this is simple.
Here's a version that works but at a high cost - an atrocious data model
see attached.
