Pages

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

NOTE : 
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)



No comments:

Post a Comment