As per my understanding, you are looking for "Conditional Formatting".
The Following Example was created to know the Sales Performance.
1) Create a calculation like below syntax.
if Sum([Sales]) <= 5000 then "Red"
elseif Sum([Sales]) >5000 and Sum([Sales]) <= 25000 then "Blue"
elseif Sum([Sales]) >=25001 and Sum([Sales]) <= 50000 then "Orange"
elseif Sum([Sales]) >=50001 and Sum([Sales]) <= 75000 then "Green"
2) Drag the City Column onto Row shelf, Sales on to Text Marks pane.
And Drag the above calculation onto colors marks.
to get your required put put,
If [Rating] < 50 then "Red" elseif [Rating] = 50 then "Gray" elseif [Rating] >50 then "Green" end
You guys are on the right track and asking all the right question on your approach. With the sample data or the workbook, it is a little hard to build what you are looking for as sometime id depends on how your data is laid out.
From your details above and the attached PDF, I put together a sample workbook using few records from superstore data set. I am not sure if you are looking to exactly replicate what you have in PDF of just trying to get a stacked bar graph with different colors. You can use your dimensions on the columns and use your favorability rating as your color dimension to show the bars as stacked.
Below is a sample of stacked bar graph with total count at the top using dual axis.
Since, I am using dual axis in the above to show the totals, it will be little tricky to show the average line graph. Below, I have the stacked bars with the average, but will lose the total count on the bars. Again, we can achieve that too with little bit heavy lifting.
One alternative is to show the total next to the average value as, again this is without heavy lifting.
Hope this helps.
stacked bars-157127-kk.twbx 31.2 KB
Thanks to you both. I now understand this clearly. This appears to be a very helpful forum for Tableau :-)