Using Percentiles to Bucketize in Beast Mode Query
I have a table with a text dimension (Name) and an associated measure (Score).
I wish to do the following:
- Calculate if the Score for each Name is in the top 20th percentile of all entities (highest)
- If the Name is inside the 20th percentile, do not update the Name.
- If the name is outside of the 20th percentile, change the Name to 'Other'