Groupby count versus Flipside unique

Comments

3 comments

  • Official comment
    Joel Stewart

    Hi Philip, the unique counts calculation in Flip Side is just an estimate as documented here: https://documentation.datameer.com/documentation/display/DAS50/Flip+Side#FlipSide-ReadingFlipSidecharts

    Counting the number of groups from a GroupBy function will provide the precise count of unique values. 

    Comment actions Permalink
  • Philip Grant

    Thanks Joel,

    Follow up question: If I have a string field how can i get an exact count of unique groups?

    Right now, this goofy so prepare yourself, I'm using the groupby function to get my unique groups with a groupcount as function of the groupby and isblank as a function groupcount, which produces a field of false values, which i can groupcount and get the number of groups from my original groupby.  I noticed that the number of groups using this method is equal to the number given for records once the groupby function has been applied. 

    0
    Comment actions Permalink
  • Joel Stewart

    There are many ways to do this, most simply it could be accomplished with these two functions in a new sheet:
    GROUPBY(1)
    GROUPCOUNTDISTINCT(#MyStringColumn)

    This will be a precise count when the workbook runs and you view the Full Data result. Note that the displayed count in the workbook is based on sample data only and may not be precise. 

    0
    Comment actions Permalink

Please sign in to leave a comment.