All tagged Table Calculations

Nested Ranks for Multiple Dimensions in Tableau

Rank is a very powerful concept in Tableau and one of the widely used Table Calculations. It can be used in many situations along with other Helper functions like Index(), First(), Last() and Size(). It can also be very effectively leveraged for Pagination.

In this blog, we will focus on the Top Ranks using multiple Dimensions within the same visualization for the same measure.

Top N and Bottom N in Tableau - 4 Methods

What should a report convey? What is the end user interested in? Should we present only the best data points (strength of the data) so that the end uses are happy customers? Should we show only the weakest data points which gives room for improvement and further investigation?

How about we show the good points and bad points together? This can be done in many ways. We can show Rank charts or build Highlight tables or Heat maps or KPI shapes etc.

To keep it simple, for this blog, we are going with a simple Top N and Bottom N Bar chart. The number of values N can be static or controlled by a Parameter.