How can I change the sort order applied to funnel diagram portlets, such as the Life Cycle Funnel?
In portfolio management, the Life cycle funnel can be shown from "Analyze" tab. The information is always shown in alphabetical order.
The NSQL query behind the portlet contains the following SQL command which sorts them alphabetically:
[...] GROUP BY CA.ODF_OBJECT_CODE, PROCESS_CODE, STAGE_CODE_CAPTION, STAGE_NUMBER, PORTFOLIO _ID, SCENARIO_ID, COMPARE_TO_SCENARIO_ID, STATUS, ROLE_ID, BOOKING_STATUS_ID [...]
This is working as expected,and the NSQL query cannot be modified. We suggest to add a "number" in front to the text such us: