Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Thursday, January 22, 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