[news.eclipse.birt] Re: Crosstab w/ stacked bar chart & optional Y serie

[jponeill@xxxxxxxxxxxxxxxxx ( Jim)]

Jason, 

I'm not familiar with how to attach files here, but below are some 
snippets of the (sample) report file and data. 

In the Cross Tab I want to show the Due Date and Division dimensions as 
rows. And in the "summarized" section of the CrossTab I want to show a 
stacked bar chart with the total number of bugs, stacked by their 
priority. I can do this in excel but cannot in BIRT as far as I can tell. 
It looks like it might work if I could specify priority as the Optional Y 
series for the chart data definition, but that is "greyed" out.

With the data below the crosstab should look something like the following, 
the [] indicating how many of each priority (color coded, eg. priority 1 
is red, 2 is yellow, 3 is blue).


-Jim


** Sample CrossTab 

11/6/2008		
	Central	[-][---------]
	East	[-][-]
	West	[-----][-][------------]
11/7/2008		
	Central	[-------][---------]
	East	[----][-----]
	West	[------------][----------][--------------]


** Sample Data

Due Date,Division,Priority,Bug Count
11/6/2008,West,1,5
11/6/2008,West,2,1
11/6/2008,West,3,12
11/6/2008,Central,1,1
11/6/2008,Central,3,9
11/6/2008,East,1,1
11/6/2008,East,2,1
11/7/2008,West,1,3
11/7/2008,West,2,6
11/7/2008,West,3,8
11/7/2008,Central,1,4
11/7/2008,Central,3,7
11/7/2008,East,1,2
11/7/2008,East,2,1
11/7/2008,West,1,9
11/7/2008,West,2,4
11/7/2008,West,3,6
11/7/2008,Central,1,3
11/7/2008,Central,3,2
11/7/2008,East,1,2
11/7/2008,East,2,4



** Cube definition
   <cubes>
       <tabular-cube name="Data Cube" id="8">
           <property name="dimensions">
               <tabular-dimension name="Group" id="9">
                   <property 
name="defaultHierarchy">NewTabularHierarchy</property>
                   <property name="hierarchies">
                       <tabular-hierarchy name="NewTabularHierarchy" 
id="10">
                           <property name="levels">
                               <tabular-level name="Due Date" id="11">
                                   <property 
name="dataType">string</property>
                                   <property name="columnName">Due 
Date</property>
                               </tabular-level>
                               <tabular-level name="Division" id="12">
                                   <property 
name="dataType">string</property>
                                   <property 
name="columnName">Division</property>
                               </tabular-level>
                               <tabular-level name="Priority" id="13">
                                   <property 
name="dataType">string</property>
                                   <property 
name="columnName">Priority</property>
                               </tabular-level>
                           </property>
                       </tabular-hierarchy>
                   </property>
               </tabular-dimension>
           </property>
           <property name="measureGroups">
               <tabular-measure-group name="Summary Field" id="14">
                   <property name="measures">
                       <tabular-measure name="Bug Count" id="15">
                           <property name="function">count</property>
                           <expression 
name="measureExpression">dataSetRow["Bug Count"]</expression>
                           <property name="dataType">integer</property>
                       </tabular-measure>
                   </property>
               </tabular-measure-group>
           </property>
           <property name="dataSet">Data Set</property>
       </tabular-cube>
   </cubes>