Tableau Tip Tuesday: How to group items into dynamic halves, tertiles, quartiles, and quintiles

This week's tip came about from a client request at The Data School last week. The customer was looking to understand how quickly different doctors adopted different medications. I worked with Alexander Fridriksson to solve this problem using table calculation.

In Alexander's example, he needed to break the customers down into thirds: early adopters, the next 33% of adopters and late adopters. The beauty of this solution is that it dynamically recategorizes the doctors based on the marks in the view.

As we can't share specific client examples, this video shows you how to use the RANK_PERCENTILE table calculation to "bin" states based on their adoption date. An adoption rate in this case is the first time a product was sold in a category.

Enjoy!