Hi everyone - I'm trying to chart 2 entities on a single chart and need some help. The goal is to show YTD GM (a sum of multiple records in my activeprograms entity) side-by-side with that users' GM target (a field called new_2017gmtarget in my user entity). I've tried to follow the guidance of CRM Chart Guy (https://crmchartguy.wordpress.com/2014/02/24/multiple-entities-in-one-ms-crm-chart/) on how to get the 2 entities in the chart but am having trouble with my code re-importing. Error: The specified record does not exist. Can someone look at my XML please?
<visualization>
<visualizationid>{034B3A10-BC30-E711-8128-70106FA9E1E1}</visualizationid>
<name>2017 YTD Realized GM</name>
<primaryentitytypecode>activeprograms</primaryentitytypecode>
<datadescription>
<datadefinition>
<fetchcollection>
<fetch mapping="logical" aggregate="true">
<entity name="activeprograms">
<attribute name="ownerid" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" />
<link-entity name="user" from="ownerid" to="systemuserid" link-type="outer">
<link-entity name="user" from="ownerid" to="systemuserid" link-type="outer">
<attribute alias="GMTarget" name="new_2017gmtarget_base" aggregate="sum" distinct="true" />
<filter type="and">
<condition attribute="statecode" operator="eq" value="0" />
</filter>
</link-entity>
</link-entity>
<attribute name="new_total2017gm_base" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_13" />
</entity>
</fetch>
</fetchcollection>
<categorycollection>
<category alias="_CRMAutoGen_groupby_column_Num_0">
<measurecollection>
<measure alias="GMTarget" />
</measurecollection>
<measurecollection>
<measure alias="_CRMAutoGen_aggregate_column_Num_13" />
</measurecollection>
</category>
</categorycollection>
</datadefinition>
</datadescription>
<presentationdescription>
*This post is locked for comments
I have the same question (0)
