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