Group By & then do distinct count by a ticket number column

[jcastr02]

I have a list that has ticket numbers that could be repeating so I'm looking to do a data transform and group by the File_Date and then do a distinct count of rows but on the ticker number column, but when I try to select column, it is greyed out.  Does anyone have any other work arounds?

[VahidDM]

Hi @jcastr02 

An easy way to do that is to delet other columns befor group by and just keep File_Date and ticker number columns.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[jcastr02]

Thanks @VahidDM  I'd eventually need the category column, because I'd need to group by that too.  Any other thoughts?