2 Replies Latest reply on Nov 2, 2016 4:05 PM by Max Wong

    Ranking Top Product Not ranked properly

    Max Wong

      Hi all,


      I was wondering if anyone would be able to help me with correcting the labels for product ranking. I have managed to label the ranks based this Tableau article (Finding the Top N Within a Category | Tableau Software). However, there's on week with the wrong ranking number (see below image):

      Ranking problem.png

      How is it that on Week 11, the Action Name with one conversion was ranked as number 2? Also, for the quick table calculation for Top N, I had to compute using Action Name and not Pane (down) because doing so will show the rank as 1 for all Action Names.


      Is there a way to ensure that the ranking would change be ranked dynamically as well since the dataset I am using is connected to Microsoft Analysis Service. As much as I would like to, I am unable to export the workbook since it contains client information.


      Any help would be greatly appreciated and thanks in advance!