locked
Multiple Groupings on an X-axis on a Chart RRS feed

  • Question

  • Hi All,

     

    Im looking to make a chart that will display multiple groupings on an X-axis. On the X-axis i want to have the Stage an Opporntunity is in (meeting scheduled, negotiaion, ect.) and the who the Opportunity Owner is. The Y-axis will show the number of records for each person and stage.

    Below is an image of what i'm trying to achieve.

     


    • Edited by J221221 Wednesday, October 19, 2011 3:49 PM
    Wednesday, October 19, 2011 3:23 PM

Answers

  • Hi

    You should be able to achieve this using comparison charts (2 group bys). A sample definition that you may import is as follows:

    	<visualization>
    		<name>Opportunities By Stage and Owner</name>
    		<description>Shows the number of opportunities grouped by stage and owner.</description>
    		<datadescription>
    			<datadefinition>
    				<fetchcollection>
    					<fetch mapping="logical" aggregate="true">
    						<entity name="opportunity">
    							<attribute alias="aggregate_column" name="opportunityid" aggregate="count" />
    							<attribute groupby="true" alias="groupby_stage" name="stage" />
    							<attribute groupby="true" alias="groupby_owner" name="ownerid" />
    						</entity>
    					</fetch>
    				</fetchcollection>
    				<categorycollection>
    					<category>
    						<measurecollection>
    							<measure alias="aggregate_column" />
    						</measurecollection>
    					</category>
    				</categorycollection>
    			</datadefinition>
    		</datadescription>
    		<presentationdescription>
    			<Chart Palette="None" PaletteCustomColors="97,142,206; 209,98,96; 168,203,104; 142,116,178; 93,186,215; 255,155,83; 148,172,215; 217,148,147; 189,213,151; 173,158,196; 145,201,221; 255,180,138">
    				<Series>
    					<Series ChartType="StackedColumn" Font="{0}, 9.5px" LabelForeColor="59, 59, 59"  CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" ></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">
    							<MajorGrid Enabled="False" />
    							<MajorTickMark Enabled="False" />
    							<LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
    						</AxisX>
    					</ChartArea>
    				</ChartAreas>
    				<Titles>
    					<Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="0, 0, 0"></Title>
    				</Titles>
    			</Chart>
    		</presentationdescription>
    	</visualization>
    
    
    


    Abhishek Agarwal MSFT
    Thursday, October 20, 2011 4:25 PM