Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Pipeline Chart re-order - Option Set Values

(0) ShareShare
ReportReport
Posted on by

Hi, I have a pipeline chart that needs to be re-ordered.  I have an Intake Stage OS that needs to be re-ordered by OS value.  However, I do not want to change the OS values as they may be referenced by automation and do reference existing values in Prod.  Here are screenshots to illustrate:

pastedimage1638884929445v1.png

In the above screenshot, the 8 - Welcome to ACES should be at the bottom of the funnel, but it is not bc the value is 006

pastedimage1638885014302v2.png

I have the XML, which probably then needs an update.  If anyone has ideas on how the XML can be updated to re-order, I would greatly appreciate it!  Thanks in advance.

<visualization>
<visualizationid>{C6D86C62-532B-EC11-B6E5-000D3A5BA89E}</visualizationid>
<name>Onboarding Pipeline</name>
<description>Shows the sum Intake Stages in each stage of the sales pipeline.</description>
<primaryentitytypecode>opportunity</primaryentitytypecode>
<datadescription>
<datadefinition>
<fetchcollection>
<fetch mapping="logical" aggregate="true" count="8">
<entity name="opportunity">
<order alias="sum_estimatedvalue" descending="true" />
<attribute name="aces_intakestagecode" aggregate="count" alias="sum_estimatedvalue" />
<attribute name="aces_intakestagecode" groupby="true" alias="stepname" />
</entity>
</fetch>
</fetchcollection>
<categorycollection>
<category alias="stepname">
<measurecollection>
<measure alias="sum_estimatedvalue" />
</measurecollection>
</category>
</categorycollection>
</datadefinition>
</datadescription>
<presentationdescription>
<Chart Palette="None" PaletteCustomColors="91,151,213; 237,125,49; 160,116,166; 255,192,0; 68,114,196; 112,173,71; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 124,175,221; 241,151,90; 186,144,192; 255,205,51; 105,142,208; 140,193,104; 50,125,194; 210,96,18; 150,83,159; 204,154,0; 51,90,161; 90,138,57;">
<Series>
<Series ShadowOffset="0" IsValueShownAsLabel="true" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" ChartType="Funnel" CustomProperties="FunnelLabelStyle=Outside, FunnelNeckHeight=0, FunnelPointGap=1, FunnelNeckWidth=5">
<SmartLabelStyle Enabled="True" />
</Series>
</Series>
<ChartAreas>
<ChartArea>
<Area3DStyle Enable3D="false" />
</ChartArea>
</ChartAreas>
<Legends>
<Legend Alignment="Center" LegendStyle="Table" Docking="right" Font="{0}, 11px" ShadowColor="0, 0, 0, 0" ForeColor="59, 59, 59" />
</Legends>
<Titles>
<Title Alignment="TopLeft" DockingOffset="-3" Font="Segeo UI, 13px" ForeColor="0, 0, 0" />
</Titles>
</Chart>
</presentationdescription>
<isdefault>false</isdefault>
</visualization>

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,253 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans