Forum Discussion
Distinct count two different columns by group
Hello, I'm trying to count how many times a certain string value is repeated across a group of IDs. By using DISTINCTCOUNT this works perfectly when only counting a column, but I can't get around to...
Apologies, this is above my paygrade...
Maybe you could duplicate the table in query edit, strip out everything that isn't needed for this, unpivot it, link it back on ID:
If that doesn't I don't think I can solve it 🙂
I might have misunderstood but try this:
- edit the query for your table,
- select id column
- unpivot other collumns
so it looks like:
Then save the query and make your matrix:
Result:
Hope the helps! 🙂
Hi! Thanks for the help.
Is there a way other than by unpivoting columns? Thing is, this is a great simplification of my real data (one that already has been unpivoted). I want to avoid doing it again.