I have a simple pie chart that shows the breakdown of projects by a status indicator. It is based on the project object. The values of the status indicator (a status lookup) are:
In the lookup, the values are ordered as above.
I have set the color palette in System Options to be ordered Red, Yellow, Green, etc. so that this (and other similar) portlets have sensible colors for the values represented.
I would expect that the values would load in this order (since that is how they are ordered in the lookup), so that Green corresponds with 1-On Track, Yellow with 2-At Risk, Red with 3-Critical. The colors are loading in the proper order but not the values, so the values and colors do not match up (see attached screen shot). I have also set the sort column in the portlet options to this value, but it doesn't change anything.
Does anyone know how to set the order of values in a portlet?