How to count unique value in a column


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!


  • dthierjung

    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.