2 Diagramme mit unterschiedlichen Daten (Filter) in einem Diagramm gemerged darstellen

Question

Hallo Leute,

Ich scheitere gerade darann 2 Diagramme in einem darzustellen.

Ich möchte die LEAD Information "Geschätzter Umsaz" darstellen. wobei ich hier in einem Chart die Umsätze von mehreren Jahren darstellen möchte was dann in etwa so aussehen soll:

Ich wollte das im XML folgendermaßen abdecken:

Der Import erkennt das XML als korrekt, aber beim fertigstellen bekomme ich die Meldung, dass er die 2. KAtegorie nicht findet.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: DataDescription is invalid. Category alias: _CRMAutoGen_groupby_column_Num_1 is invalid or not found in fetch collection.Detail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147164160</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>DataDescription is invalid. Category alias: _CRMAutoGen_groupby_column_Num_1 is invalid or not found in fetch collection.</Message>
  <Timestamp>2012-06-04T08:30:36.6161727Z</Timestamp>
  <InnerFault i:nil="true" />
  <TraceText i:nil="true" />
</OrganizationServiceFault>

Hat schon mal jemand so etwas versucht?

Answer 1

Hier ist die komplette XML Struktur:

<visualization>
  <visualizationid>{3525DEAE-19AE-E111-933F-1CC1DE6D3B23}</visualizationid>
  <name>Gesch. Wert, Gesch. Abschlussdatum</name>
  <primaryentitytypecode>lead</primaryentitytypecode>
  <datadescription>
    <datadefinition>
      <fetchcollection>
		<fetch mapping="logical" aggregate="true">
		  <entity name="lead">
			<attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="estimatedamount" aggregate="sum" />
			<attribute name="estimatedclosedate" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" dategrouping="month"/>
			<filter type="and">
			  <condition attribute="ownerid" operator="eq-userid" />
			  <condition attribute="statecode" operator="eq" value="0" />
			  <condition attribute="estimatedclosedate" operator="on-or-before" value="2010-12-31" />
			  <condition attribute="estimatedclosedate" operator="on-or-after" value="2010-01-01" />
			</filter>
		  </entity>
		  <entity name="lead">
			<attribute alias="_CRMAutoGen_aggregate_column_Num_1" name="estimatedamount" aggregate="sum" />
			<attribute name="estimatedclosedate" groupby="true" alias="_CRMAutoGen_groupby_column_Num_1" dategrouping="month"/>
			<filter type="and">
			  <condition attribute="ownerid" operator="eq-userid" />
			  <condition attribute="statecode" operator="eq" value="0" />
			  <condition attribute="estimatedclosedate" operator="on-or-before" value="2011-12-31" />
			  <condition attribute="estimatedclosedate" operator="on-or-after" value="2011-01-01" />
			</filter>
		  </entity>
		</fetch>
	 </fetchcollection>
      <categorycollection>
        <category alias="_CRMAutoGen_groupby_column_Num_0">
          <measurecollection>
            <measure alias="_CRMAutoGen_aggregate_column_Num_0" />
          </measurecollection>
        </category>
		<category alias="_CRMAutoGen_groupby_column_Num_1">
          <measurecollection>
            <measure alias="_CRMAutoGen_aggregate_column_Num_1" />
          </measurecollection>
        </category>
      </categorycollection>
    </datadefinition>
  </datadescription>
  <presentationdescription>
    <Chart Palette="None" PaletteCustomColors="55,118,193; 197,56,52; 149,189,66; 117,82,160; 49,171,204; 255,136,35; 97,142,206; 209,98,96; 168,203,104; 142,116,178; 93,186,215; 255,155,83">
      <Series>
        <Series ChartType="Line" IsValueShownAsLabel="True" BorderWidth="3" MarkerStyle="Square" MarkerSize="9" MarkerColor="37, 128, 153" MarkerBorderColor="37, 128, 153"></Series>
		<Series ChartType="Line" IsValueShownAsLabel="True" BorderWidth="3" MarkerStyle="Square" MarkerSize="9" MarkerColor="37, 1, 153" MarkerBorderColor="37, 1, 153"></Series>
      </Series>
      <ChartAreas>
        <ChartArea BorderColor="White" BorderDashStyle="Solid">
          <AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount">
            <MajorGrid LineColor="239, 242, 246" />
            <MajorTickMark LineColor="165, 172, 181" />
            <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
          </AxisY>
          <AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount">
            <MajorTickMark LineColor="165, 172, 181" />
            <MajorGrid LineColor="Transparent" />
            <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
          </AxisX>
        </ChartArea>
      </ChartAreas>
      <Titles>
        <Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="59, 59, 59"></Title>
      </Titles>
      <Legends>
        <Legend Alignment="Center" LegendStyle="Table" Docking="right" IsEquallySpacedItems="True" Font="{0}, 11px" ShadowColor="0, 0, 0, 0" ForeColor="59, 59, 59" />
      </Legends>
    </Chart>
  </presentationdescription>
  <isdefault>false</isdefault>
</visualization>