One Line of Code to Get Both Top N & Bottom N
There seem quite a few other posts regarding how to get top N and bottom N. It is a recurring topic. Here is an example:
How to create Top 5 and Bottom 5 values with respect to a Measure in Bar graph in same worksheet
Just figured out a simple way of dealing with this class of questions.
Min Date, Max Date and Where is My Date
Very often people need to get the measure value on the max(Date), or the min(Date), or next to max(Date), or a date relative to the min/max date etc. (Date can be in Year, Quarter, Month, Week, Day or even second.) It is often a struggle to pick out that date and its associated measure value.
Two Articles Selected as Best of Tableau Web March 2015
Two articles have been selected as Best of the Tableau Web March 2015 :
Grouping Lower % Bars in Bar Chart
Nested Sorting and Top N per Category via Rank_Unique
Excited about the selection.
Binning Aggregates for Histogram and Aggregate Distributions
There are two aggregates in the title. One is for creating bins. The other is for calculating distribution over bins of aggregate functions like sum, average, count etc. In case of count distribution, it is also known as histogram.
3
