11 Replies Latest reply on May 1, 2018 3:24 AM by Jyothisree Rayagiri

    How do I sort and rank multiple columns/dimensions in a crosstab and isolate the top/number 1?

    Tiago-Mateus Korynek

      I have a table of data which contains Registration and Total Minutes of a Delay duration. What I would like to do is isolate the worst performing registration based on the condition of Most occurrences (in the period of time set by the filter) and then if there are multiple Registrations fighting for top spot based on the Most occurrences, I would like to order them based on the Sum of the Total Minutes of Delays. Once they are all sorted, I would like to see just the winner (effectively displaying the Worst performing Registration).

       

      How would I go about doing this? A friend told me I should consider using Index() and I have made an attempt to do so, but have not been able to get it to work.

       

      I am using Tableau 10.4 and if anything else needs explaining of what I am trying to achieve and how, then please let me know.