Update: These options are good if you are using Tableau 8.3 or earlier. But if you’re using 9.0 or later, here is a much better option: Level of Detail Calculations.
- Show me a distribution of customers by the number of items they bought.
- How many students took how many classes?
- How many people responded to our advertisements? How many advertisements did it take?
All of these questions require a special kind of slicing. Normally, we group or slice data by dimensional values. Bins are special dimensions based on measures, but they don’t aggregate the measures first. How would we be able to show the count of classes taken by individual students and then show an aggregate count of the number of students at each of the values? Here’s a workbook that gives some options.
Have any other options? Leave a reply…