First thing to note, make sure your header is the top line in your Excel file.
Not sure by your above specs what the exact question is but if your color requirement is strictly based off of a single cell value then the equation would be something like:
If [Test Passed Percentage] =1 then 'green'
elseif [Test Passed Percentage] >= .9 then 'yellow'
If the values need to be aggregate calcs like an average then the calc would need to account for that as well
Not sure how "green" you are with Tableau so if you need any further explanation let me know.
If the above logic doesn't match what the requirement is let me know.
Based on this logic for % column I need to apply color in the worbook. for example,
if[Test Passed Percentage] = 100 then 'green'
elseif [Test Passed Percentage] <90 then 'red'
elseif [Test Passed Percentage] >90 and [Test Passed Percentage] <100 then 'yellow'
the data type for Test Passed Percentage is 'String' and then I changed it to 'INT' so that above logic can be used.
The above logic is valid and then I placed the calculated field in a color shelf and change the color. But i'm not able to see colors applied to the cells in the workbook.
Is there anything i'm doing wrong or missing. How do i apply color based on above logic?
The logic for the calculated field should be:
IF [Tests Executed Percentage]<.9 THEN 'red' ELSEIF [Tests Executed Percentage]<1 THEN 'orange' ELSE 'green' END
I attached a workbook based on your data that includes three different alternatives. Please, take a look at it to see if it helps to solve your requirements.
ApplyColor.twbx 131.1 KB
I'm using tableau 7.1, could you please send me the workbook created in 7.
I don't have version 7.1 with me now.
Let me see what I can do.