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

Friday, 23 January 2015

Tip : Adding trend Lines to Fusion Charts in Jasper Studio 6.x ( Adding average trend line in jasper studio to a bar chart)

This post will give you the starting point of working with trend lines in jasper studio .

Adding trend Lines to Fusion Charts in Jasper Studio 6.x  ( Adding average trend line in jasper studio to a bar chart)

Software Setup : Jasper Studio Pro 6.x, Jasper Server 6.x Pro, foodmart db.

Sample Data : 

OUTPUT image : 



Steps : 
1) Create a variable and calculate Avg as shown in below image.




2) Give this variable( it should be of integer type though your field may output BigDecimal values) for Start Value Expression & End Value Expression as shown image.

                           

NOTES : 
Can we find moving average trend lines in jasper ? NO.

References : 
1) How to add advanced properties :
http://community.jaspersoft.com/wiki/how-wrap-labels-pie-chart-pro

2) Customization properties
http://docs.fusioncharts.com/flex/charts/Contents/xml_elements_trend.html

3) http://en.wikipedia.org/wiki/Linear_regression