Pentaho 1.0 Collector XML Examples

These samples apply to the 1.0 version of Pentaho.

Line, Bar, and Area Chart Data Collector Example*

<expression class="org.pentaho.jfree.reportcharts.CategorySetCollectorFunction" name="chartDataSource">
 <properties>
  <property name="categoryColumn">CUSTOMERNAME</property>
  <property name="seriesName[0]">Customer Sales</property>
  <property name="seriesName[1]">Customer Margin</property>
  <!-- <property name="seriesName[n]">Series Name</property> -->
  <property name="valueColumn[0]">Total Sales</property>
  <property name="valueColumn[1]">Margin</property>
  <!-- <property name="valueColumn[n]">Column Name</property>  -->
  <property name="summaryOnly">false</property>
  <!-- <property name="group">Customer_Type</property> --><!--  Only use if summaryOnly=true -->
 </properties>
</expression>

Pie Chart Data Collector

<expression class="org.pentaho.jfree.reportcharts.PieSetCollectorFunction" name="ChartDataSource">
  <properties>
     <property name="group">RegionGroup</property><!\-\-  Only use if summaryOnly=true \-\->
     <property name="seriesColumn">REGION</property>
     <property name="valueColumn">RegionBudget</property>
     <property name="summaryOnly">true</property>
  </properties>
</expression>