3 Replies Latest reply on Sep 29, 2014 1:27 AM by ankit.narula

Conditional coloring in a row pane

Anjaiah K Apr 23, 2012 6:20 AM

Hi,

I have been trying this since friday and no luck as of now. I need to color back ground of a row by comparing total percentage calculated on a row pane. The conditions are

1.If the Quadrant = 2 in the row is greater than the bottom row (the total), color the background behind the three numbers GREEN

Example For "WT" = "B"; "band" = "B"; and "CS" = "NO", there were two data points: one with Quadrant = 2 is 63.64 % is higher than the column total (40.63% Effective), color this row( 18.18%,63.64%,18.18%) GREEN.

2.If the Quadrant = 1 in the row is greater than the the bottom row (the total), color the background behind all three numbers RED

3. If both of the above are true, color the individual numbers RED or GREEN as shown in the example in the upper right of the attached powerpoint quarter 2 cell value should be green and quarter1 cell value should be red and quarter 3 should be white.Otherwise, color the background behind all three numbers WHITE

Can some one help on this? Thanks in advance.

Sample workbbok.twbx.zip 20.7 KB

1. Re: Conditional coloring in a row pane

Anjaiah K Apr 23, 2012 6:32 AM (in response to Anjaiah K)

Pic attached. I have just highlighted but cell should colored fully. I do not have any values two criteria at the movement here but in actual the third condition happens. we should have both colors in for both CS=Yes and CS=no
Like Show 0 Likes(0)

Actions
2. Re: Conditional coloring in a row pane

Jonathan Drummey May 4, 2012 2:20 PM (in response to Anjaiah K)

Hi Anjaiah,

I took a look at this and got most of the way there in terms of coloring, then I had to put it down for a few days. Are you still looking for help doing this?

Jonathan
Like Show 0 Likes(0)

Actions
3. Re: Conditional coloring in a row pane

ankit.narula Sep 29, 2014 1:27 AM (in response to Jonathan Drummey)

Hi ,

I was looking for some help and happened to see your post.
I am actually looking to colour only one column and when I am trying to do shading through format of that ,its colouring every column.

Can you help?

Thanks
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Conditional coloring in a row pane

1. Re: Conditional coloring in a row pane

2. Re: Conditional coloring in a row pane

3. Re: Conditional coloring in a row pane

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account