How to count unique value in a column

user02591
user02591
in Magic ETL

If I have a following list of data - 1,1,2,2,2,3,3,3,3,4,5,5,6,6,6 and I want to know how many unique value in this list, in this case, it's 6.  How to do it in DOMO? Thank you!

Comments

  • dthierjung
    dthierjung Contributor

    You can create a Beast Mode function in any card and use the following function to return the unique values:

     

    COUNT(DISTINCT `column_name`)

     

    The distinct key word returns the unique values.

     

    Let me know if that helps.

Categories