<< Back
24 September, 2012 | Tom Brown

Using INDEX to create a rank in Tableau – Within a Category (Video)

This video is the second in a series of videos which aim to explain the use of the index() function in Tableau – specifically for using it to provide a rank of data points.

If you are new to the subject, and have not yet watched the first video, I suggest you go here first:

http://www.theinformationlab.co.uk/2012/08/09/using-index-to-create-a-rank-in-tableau-video/

 

In the second video, we demonstrate how to make the rank value restart within a new category.

 

 

Related posts

Getting started with the index() function in Tableau (video)

Making Table Calculations work

Tom Brown

London, UK

3 thoughts on “Using INDEX to create a rank in Tableau – Within a Category (Video)”

  1. Thanks for the great video, but this doesn’t seem to work unless the rows are sorted. How would one set it up so that if the rows are jumbled up the rank value would still be correct?

    Reply

    1. I dont think it can be done with this version of Tableau. Also what is not possible is to rank multiple metrics. There is a blog post out there which teaches a trick or two using the index and look up functions together but it only addresses different ranking functions like standard or dense ranking and still suffers from the sorting issue. Tableau 8.1 solves the issue by supporting ranking functions now.

      Reply
  2. Pingback: 5 dingen welke ik had willen weten toen ik met Tableau begon | The Information Lab Netherlands - Tableau Gold & Alteryx Premium Partner

Leave a Reply

Your email address will not be published. Required fields are marked *