Gonzalo Perez Farina

Updated December 20, 2021 19:21

COUNT(DISTINCT column) in C9QL

Follow

Hello! 

How can I do a COUNT of unique values of a column? 

In SQL it would be something like:

SELECT Message Type, SUM(Sent), COUNT(DISTINCT Campaign_name)
GROUP BY Message Type

I couldn't make it work in C9QL though :( 

• Official comment

  

  Brigham Berry December 22, 2021 00:28 (Edited December 22, 2021 00:28)

  Hi Gonzalo,

  Try Count(distinct(<Field>)).

   

  Comment actions Permalink
• 

  Gonzalo Perez Farina December 22, 2021 14:33

  Thanks a lot, Brig!

  Not proud of myself with that one 😇

  0

  Comment actions Permalink

Please sign in to leave a comment.