Thanks Ulrik - I used the view workaround to exclude the blanks and it works perfectly.
The link you sent for changing the xml in the charts is great (added as a favorite). I am still having issues figuring out how to set a chart data to ascending or descending the data. Could you look at the xml data below and tell
me where to insert the command and what to put? I went off one of the examples you sent me and tried placing <order alias='year' descending='false' /> into where I thought was the appropriate spot but when I try and import back in it tells me the
code isn't formatted correctly.
<visualization>
<visualizationid>{A96BA01D-35C9-E211-B5BC-D8D385E6B5BF}</visualizationid>
<name>Hired/Placed (no blanks</name>
<primaryentitytypecode>new_candidate</primaryentitytypecode>
<datadescription>
<datadefinition>
<fetchcollection>
<fetch mapping="logical" aggregate="true">
<entity name="new_candidate">
<attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" name="new_datahiredplaced" dategrouping="fiscal-year" />
<attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="new_candidateid" aggregate="countcolumn" />
</entity>
</fetch>
</fetchcollection>
<categorycollection>
<category alias="_CRMAutoGen_groupby_column_Num_0">
<measurecollection>
<measure alias="_CRMAutoGen_aggregate_column_Num_0" />
</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>
<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>
</Chart>
</presentationdescription>
<isdefault>false</isdefault>
</visualization>
Dynamics CRM Recruiting Tinkerer
