Hi all. Hoping someone has a good trick for this; I've exhausted all the suggestions I can find on it. Stacked bar chart component is sorted by a bucketed field. I don't really care whether it's 1 to 9 or vice versa but it's randomly out of order for stages in between. I've tried renaming both the stages and the buckets with 1, 2 or 01., 02. etc but it still won't behave. I know this has been a weird bug for a while but wondering if anyone cracked it. I even tried a sort order formula field to force it but no luck.
Please see screen shot - why won't #5 behave? Thanks.
#Sales Cloud #Reports & Dashboards
Even with this sort order formula field in grouping, it still puts it out of order:
CASE(
TRIM(TEXT(STAGE_NAME)),
"1 - Need Identified", "01. 1 - 3 Pipe: Disc to Prove Concept",
"1 A - Discovery", "01. 1 - 3 Pipe: Disc to Prove Concept",
"1 B - Business Evaluation", "01. 1 - 3 Pipe: Disc to Prove Concept",
"2 - Problem Defined", "01. 1 - 3 Pipe: Disc to Prove Concept",
"2 A - Technical Qualification", "01. 1 - 3 Pipe: Disc to Prove Concept",
"2 B - Validate Solution", "01. 1 - 3 Pipe: Disc to Prove Concept",
"3 - Solution Proposed", "01. 1 - 3 Pipe: Disc to Prove Concept",
"3 - Proving the Concept", "01. 1 - 3 Pipe: Disc to Prove Concept",
"4 - Criteria Evaluation", "02. 4 Upside: Negotiation",
"4 - Negotiations", "02. 4 Upside: Negotiation",
"5 - Contracting", "03. 5 Commit",
"5 - Commit", "03. 5 Commit",
"6 - PO Received", "04. 6 - 8 Closed",
"7 - Order Released to Production", "04. 6 - 8 Closed",
"7 - Back ordered", "04. 6 - 8 Closed",
"8 - Product Built and Shipped", "04. 6 - 8 Closed",
"8 - Awaiting Delivery", "04. 6 - 8 Closed",
"05. 9 Rev Rec"
)