Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoAssuming that these phases are chosen from a multiple-choice test you should be able to set the field properties for that multiple choice list sort "in the order listed above". Just make sure they are listed in the order that you want.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- AnnettaColeman4 years agoQrew CadetThe multiple choice field does have them 'in the order listed above'. The problem is that when I create a pie or funnel (or any other) graphical chart using that field as the series, the chart is displayed by either label (alphabetic) or value (of the contents). Clearly a chart like a funnel chart needs to be in a specific order. I created another formula text field to place a leading number prefix, but that solution is too clunky for our executives. I shouldn't have to convert Initiating, Planning ... Closing Phases to 1.Initiating, 2.Planning ... 5.Closing to simply control the order through the funnel. Ugh!! What other options can control series label order?
------------------------------
Annetta Coleman
------------------------------- MarkShnier__You4 years ago
Qrew Legend
I think you are stuck with numbering. I looked back on a Funnel chart I did and I see that I had to number it as well.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- MarkShnier__You4 years ago
Qrew Legend
If you want to hide the numbering though what you can do is have a formula Field that prefaces the phases with an appropriate number of leading spaces on each phase so that they sort alphabetically.
A space as a prefix sorts first in the alphabet and two Spaces sorts higher than one space. So you play around with the spaces in a formula field called [Phases sorted] and the the executive users will never notice the leading spaces.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------