Groupby count versus Flipside unique
I'm trying to figure out why unique count for a given field in Flip side is different from a count of groups (groupby) for the same field.
-
Official comment
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 -
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.
-
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.
Please sign in to leave a comment.
Comments
3 comments