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

# Ranking Resets for each separate colour group

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

• ###### 1. Re: Ranking Resets for each separate colour group

Hi Dave,

I have tried one solution to your problem,

Desired Result :

What I did was

1.  Change the RankOnAbsolute calculation from Rank to Rank_Dense

2. Change Absolute Value Calculation

3.Edit Table Calculation of Rank on Absolute and select Specific Dimensions

then it will show the desired result. I am also attaching my workbook here.

Thanks,

Kalpit

1 of 1 people found this helpful
• ###### 2. Re: Ranking Resets for each separate colour group

Hi,

Please find the below attachment if it is working then marked as correct and helpful.

See Sheet1(2)

Thanks,

Amar D. Savale

• ###### 3. Re: Ranking Resets for each separate colour group

Thanks amar savale & KALPIT GOYAL  for your responses - appreciate that.

@ Amar : Thanks for taking time to respond with the screenshots etc. but my question was little different.

@ Kalpit : That was spot on ... so I guess from technical perspective,  for table calculation, I was not correctly choosing correct dimensions for "Compute Using" & I was also not using "level of computation i.e. deepest" & "restrating every"  part.  Thanks for your assistance, easy to follow & prompt response ... awesome mate ..more power to you...

Thanks

Dave

• ###### 4. Re: Ranking Resets for each separate colour group

Thank you, great to hear from you.