Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • robadob's avatar
    robadob
    4 years ago

    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 🙂

     

robadob's avatar
robadob
Frequent Visitor
4 years ago

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 🙂

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes, this works! Thank you.

Another way I got around to do it was duplicating the tables (One containing ID and W1, the other ID and W2) and creating a relationship with a Table with a Field that contains "Yes" and "No", this field goes in the rows of the desired visual. That way I didn't need to unpivot.