Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Thursday, 30 March 2017

Line Graph Based on Multi Select Parameter in Pentaho CDE

In this example, one can learn how to make multi-select parameter values as series in Pentaho CCC line graph. 

Display two lines when selected 2 values in drop down
 Display 1 line when selected 1 value in drop down
  Display 1 line when selected another 1  value in drop down

Make CrossTabMode=False, Series in Rows = False and make sure the chart listens to the parameter.

Look at the SQL code to understand how to pass a multi select parameter in CDE or PRD

Download : Click Me

1) Dashboard source code
2) Images
3) Sample Data for this example (.ktr file) OR .backup file (restore it any of postgresql database)