4 Replies Latest reply on Jun 16, 2019 9:59 PM by KALPIT GOYAL

    Ranking Resets for each separate colour group

    Dave Divakar

      Hi All,

       

      Sorry for asking another question, I promise my frequency of asking question will go down as I gain more experience in Tableau - till then please bare with me.

       

      Ok about the problem that I have on hand:

       

      Problem:

       

      My Ranking resets when I drop in calculated field that colour values based on Negative & Positive.

       

      Dataset:

       

      I have attached demo workbook but in summary, I have data values that are basically variances and I need to rank them from 1 to 5 - regardless of positive or negative  "as well as" colour these variances in RED & GREEN based on value is positive or negative.

       

      What I have done so far:

       

      Step 1: I converted all my variances in to absolute values using ABS function

       

      Step 2: I created 2 calculated fields (A) for Ranking based on these absolute values & (B) for colouring actual values ( NOT abs values ) based on if it is positive or negative

       

      Step 3: I applied Ranking in filter & put colour CF in to colour shelf

       

      & Result is ... I have ranking reset by each colour.  Please see screen shot example ( in created in excel )

       

       

       

       

       

       

      What I want to achieve:

      I want Ranking to stay consistent i.e. ignoring colouring

       

      Hope this makes sense.

       

      Thanks

       

      Dave