AnsweredAssumed Answered

How to control the order of items in a pie portlet

Question asked by ClareLeonard76040337 on Jan 10, 2017
Latest reply on May 26, 2017 by Dave_3.0

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:
1-On Track

2-At Risk


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?