See below for an explanation for the attached 9.2 twbx.
1) Try this formula for Rank instead:
2) You have a manual sort on the Jurisdiction, just find Unincorporated and move it to the bottom.
3) Having 3 color scales working together isn't possible with continuous values, however if we convert them to discreet we can do something similar.
I created 2 more fields, Rank2:
and Color unincorporated:
I changed Rank, Rank2 and Color unincorporated to discreet:
Then I added Color unincorporated to the color mark, and added Rank2 to the detail mark.
From here you can change the mark type to color and compute using Jurisdiction.
You can then edit the colors palette from the default, I selected the Red palette and clicked "Assign Palette".
Here you can also change the individual colors on the left by clicking them and selecting a different color from another palette.
I hope this helps.
Population Data.twbx 394.6 KB
This is amazing help, thanks so much Josh!
One last item, is there any way to sort each stacked bar chart by the rank? Since Unincorporated is listed as "0" anyway, it seems it would end up at the bottom.