This content has been marked as final.
Show 3 replies
-
1. Re: Conditional Formatting from MoM results
Tableau kumar Nov 5, 2014 2:13 AM (in response to Andrew Lemon)Hi,
1) Create the following Calculated field "Color Coding"
if ([Sales] - lookup([Sales], -1) >0 then "Green" else "Red" end
2) Drag the "Color Coding" & drag into Colors shelf.
Best Regards
Laxman Kumar
-
2. Re: Conditional Formatting from MoM results
Andrew Lemon Nov 5, 2014 10:33 AM (in response to Tableau kumar)Thank you Laxman for taking a look.
I have a couple follow up questions.
1. This formula applied to all rows in the chart- can I limit it to just one specified row? I would like to only apply to the percentage row.
2. The first month I would like to have no formatting (as of now everything in the first month is showing red) and have the comparison start on the second month
-
EASy Dashboardv4.twbx 1.6 MB
-
-
3. Re: Conditional Formatting from MoM results
Grayson Deal Nov 5, 2014 11:30 AM (in response to Andrew Lemon)