/
Pentaho 1.1 and Later Collector XML Examples

Pentaho 1.1 and Later Collector XML Examples

These examples apply to 1.1 and later of Pentaho.

Line, Bar, and Area Chart Data Collector Example

<expression class="org.pentaho.plugin.jfreereport.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.plugin.jfreereport.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>