9 Replies Latest reply on Jul 28, 2016 6:02 AM by John Sobczak

Color coding

Eshwar Prasad Jul 28, 2016 3:01 AM

HI Team,

Thanks for your support.

I have one requirement regarding color coding..

i have a text table with more 6 columns. Int he one item count column i should show in the middle of the table.

Now the requirement is, i need color code the values in the item count column based on the condition like below..

if [Item count]<=5 then "Red"

ELSEIF [Item count]>5 and [Item count]<= 20 then "Blue"

ELSEIF [Item count]>20 then "Green"

end

But when i am placing this calculation in the color only spending amount is getting effected with colors. but i need to color code only item count..

Color Coding.twbx 1.0 MB

1. Re: Color coding

Rohan Malusare Jul 28, 2016 3:20 AM (in response to Eshwar Prasad)
Hi Eshwar,

Please check the attached workbook and let me know if you have any doubt.

Thanks and regards,
Rohan Malusare.

Color Coding.twbx 605.5 KB
Like Show 0 Likes(0)

Actions
2. Re: Color coding

Eshwar Prasad Jul 28, 2016 4:18 AM (in response to Rohan Malusare)

Thanks Rohan for the reply..

I clearly mentioned that i need to display that Item count column in the middle of the table not in the last . actually that is my requirement.
Like Show 0 Likes(0)

Actions
3. Re: Color coding

John Sobczak Jul 28, 2016 4:46 AM (in response to Eshwar Prasad)

You cannot apply color to text that is in the Header section, but only the data section. If you can move your item count to the data section of the sheet then you will be able to apply color to it
Like Show 1 Likes(1)

Actions
4. Re: Color coding

John Sobczak Jul 28, 2016 4:56 AM (in response to Eshwar Prasad)
Attached is your workbook modified to what I described.

Color Coding.twbx 994.7 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
5. Re: Color coding

Mark Fraser Jul 28, 2016 5:01 AM (in response to Eshwar Prasad)

I don't have the time to help, but for completeness I wanted to link this blog
>> Data Psientist: My Favorite Tableau Trick For Work: MIN(1)
This is the best way i know of to get maximum formatting control, but it will require effort to get it set up, especially with a complex text table.

Cheers
Mark
Like Show 0 Likes(0)

Actions
6. Re: Color coding

Mahfooj Khan Jul 28, 2016 5:10 AM (in response to Eshwar Prasad)
Is that what you wanted?
workbook (version 9.3) attached for your reference. Let me know If you've any query.

Mahfooj

Color Coding-modified.twbx 997.2 KB
Like Show 0 Likes(0)

Actions
7. Re: Color coding

triveni namballa Jul 28, 2016 5:36 AM (in response to Eshwar Prasad)
Hi Eshwar,

I think we cannot apply any calculation (color coding ) to the dimension field. If you tried to apply then automatically moves to measure field.
Here i tried to perform based on your requirement, but it is not perfect answer to your question.

Kindly go through the attached workbook.

Color Coding (1).twbx 1.0 MB
Like Show 0 Likes(0)

Actions
8. Re: Color coding

Eshwar Prasad Jul 28, 2016 5:54 AM (in response to John Sobczak)

Hi John,

i did in the way how u did..

got the result like below. am i missing anything here
Like Show 0 Likes(0)

Actions
9. Re: Color coding

John Sobczak Jul 28, 2016 6:02 AM (in response to Eshwar Prasad)

There is a lot of finessing I did:

1) I used dual axis for each column
2) I removed the tick marks from Axis
3) I formatted the bottom label to be white so it was not showing. Hiding it would hide label at top as well.
4) I changed color transparency on second axis to 0 % so abc text did not show

It's all there in my workbook if you look at the logic.
Like Show 2 Likes(2)

Actions