Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

D365 CE Chart

Posted on by 7
 I want to display month wise data as a comparison between Previuos year and current years. But i am geting 1st Previous year month data and after that current year month data. But i want to combine and comapre previous year with current year month data. Can someone suggest me how to do by editing the chart XML or any idea on this
  • CU11051646-0 Profile Picture
    CU11051646-0 7 on at
    D365 CE Chart
    Is there is any alterantives, Means without adding any field  can we  edit the chart XML to get the required outPut. 
    Like this, 
     
    I ahve tried this, But it's not working for me.
    Is this is depricated or I can't do like this in current version.
     
    Your suggestion on this will be appriciated
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    D365 CE Chart
    Hi,
    Please refer to the following similar thread:
    --I describe the steps of the solution in detail in the posting.
    I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
    Regards,
    Leah
     
  • CU11051646-0 Profile Picture
    CU11051646-0 7 on at
    D365 CE Chart
    This is the XML i am using:
     
     
    <visualization>
        <visualizationid>{77020B6A-EE02-EF11-9F89-6045BDEE}</visualizationid>
        <name>Sales month-to-date compared to prior year</name>
        <primaryentitytypecode>invoice</primaryentitytypecode>
        <datadescription>
            <datadefinition>
                <fetchcollection>
                    <fetch mapping="logical" aggregate="true">
                        <entity name="invoice">
                            <attribute name="dei_gpinvoicedate" groupby="true" alias="status" dategrouping="month" />
                            <link-entity name="invoice" from="invoiceid" to="invoiceid" link-type="outer">
                                <attribute alias="LastYear" name="totalamount" aggregate="sum" />
                                <filter>
                                    <condition attribute="dei_gpinvoicedate" operator="last-year" />
                                </filter>
                            </link-entity>
                            <link-entity name="invoice" from="invoiceid" to="invoiceid" link-type="outer">
                                <attribute alias="ThisYear" name="totalamount" aggregate="sum" />
                                <filter>
                                    <condition attribute="dei_gpinvoicedate" operator="this-year" />
                                </filter>
                            </link-entity>
                        </entity>
                    </fetch>
                </fetchcollection>
                <categorycollection>
                    <category alias="status">
                        <measurecollection>
                            <measure alias="LastYear" />
                        </measurecollection>
                        <measurecollection>
                            <measure alias="ThisYear" />
                        </measurecollection>
                    </category>
                </categorycollection>
            </datadefinition>
        </datadescription>
        <presentationdescription>
            <Chart Palette="None" PaletteCustomColors="58,150,221; 104,153,32; 215,116,64; 195,107,209; 87,129,27; 119,141,241; 202,80,16; 79,107,237; 238,95,183; 0,165,175; 230,28,153; 178,124,0; 177,70,194; 0,115,81; 99,124,239; 0,139,148; 52,135,199; 148,112,189; 227,0,140; 208,98,40;">
                <Series>
                    <Series  LegendText="Last Year" ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 14px" LabelForeColor="36, 36, 36" CustomProperties="DrawSideBySide=True,PointWidth=0.75, MaxPixelPointWidth=40 "/>
                    <Series LegendText="This Year" ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 14px" LabelForeColor="36, 36, 36" CustomProperties="DrawSideBySide=True,PointWidth=0.75, MaxPixelPointWidth=40 " />
    </Series>
                <ChartAreas>
                    <ChartArea BorderColor="White" BorderDashStyle="Solid">
                        <AxisY LabelAutoFitMinFontSize="8" TitleForeColor="36, 36, 36" TitleFont="{0}, 14px" LineColor="209, 209, 209" IntervalAutoMode="VariableCount">
                            <MajorGrid LineColor="240, 240, 240" />
                            <MajorTickMark LineColor="209, 209, 209" />
                            <LabelStyle Format="" Font="{0}, 14px" ForeColor="36, 36, 36" />
                        </AxisY>
                        <AxisX  LabelAutoFitMinFontSize="8" TitleForeColor="36, 36, 36" TitleFont="{0}, 14px" LineColor="209, 209, 209" IntervalAutoMode="VariableCount">
                            <MajorTickMark LineColor="209, 209, 209" />
                            <MajorGrid LineColor="Transparent" />
                            <LabelStyle Font="{0}, 14px" ForeColor="36, 36, 36" />
                        </AxisX>
                        <AxisY2 LabelAutoFitMinFontSize="8" TitleForeColor="36, 36, 36" TitleFont="{0}, 14px" LineColor="209, 209, 209" IntervalAutoMode="VariableCount">
                            <MajorGrid LineColor="240, 240, 240" />
                            <MajorTickMark LineColor="209, 209, 209" />
                            <LabelStyle Font="{0}, 14px" ForeColor="36, 36, 36" />
                        </AxisY2>
                    </ChartArea>
                </ChartAreas>
                <Titles>
                    <Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 14px" ForeColor="214, 214, 214" />
                </Titles>
                <Legends>
                    <Legend Alignment="Center" LegendStyle="Table" Docking="right" IsEquallySpacedItems="True" Font="{0}, 12px" ShadowColor="0, 0, 0, 0" ForeColor="36, 36, 36" />
                </Legends>
            </Chart>
        </presentationdescription>
        <isdefault>false</isdefault>
    </visualization>

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans