DataCharts < DataCaster

Visual Mashup Builder

AppliBuilder User Documentation

Data Charts Documentation

The AppliBuilder Data Charts are a set of widgets for visualizing data, built on the JFreeCharts open source Java library.

Data charts widgets offer three ways of providing chart data to the widget.

Named Queries where data is read directly from the database
SQL Query, where data is read directly from the database
Script data, where the user script provides the data needed for charting

Pie Chart

The Pie chart widget accepts data as a set of value pairs. For example a named or SQL query with a two column result, where the first column is a label and the second a decimal value. Any numeric value will work for the second column. For the first, any data type can be used, which will be converted to a String.

Query Example

select NAME, VOLUME from http://datadirectory.net/Table/CHART_DB/STOCK_DATA 
where NAME in ('GOOG','MSFT','YHOO','HPQ','SUNW') and DATES = 'Jan 10, 2005'

NAME - String format
VOLUME - decimal format

Bar Chart

The Bar chart widget accepts data as a series of three-valued. For example a named or SQL query with a three column result, where the first column is the Y axis (decimal value) and the second the X axis (String value) and third a category (string corresponding to each of the bars in the bar chart). Any numeric value will work for the first column. For the second and thirs, any data type can be used, which will be converted to a String.

Query Example

select VOLUME, DATES, NAME from http://datadirectory.net/Table/CHART_DB/STOCK_DATA 
where DATES > 'Dec 31, 2005' and DATES < 'Feb 01, 2006' 
and NAME in ('GOOG','MSFT','YHOO') 


VOLUME - decimal format
DATES - String format
NAME - String format

Line Chart

Single line chart

Query Example

select NAME, VOLUME from http://datadirectory.net/Table/CHART_DB/STOCK_DATA 
where NAME in ('GOOG','MSFT','YHOO') and DATES = 'Jan 10, 2005'

Multiple line chart

Query Example

select VOLUME, DATES, NAME from http://datadirectory.net/Table/CHART_DB/STOCK_DATA 
where DATES > 'Dec 31, 2005' and DATES < 'Feb 01, 2006' 
and NAME in ('GOOG','MSFT','YHOO')

Area Chart

Query Example

select VOLUME, DATES, NAME from http://datadirectory.net/Table/CHART_DB/STOCK_DATA 
where DATES > 'Dec 31, 2005' and DATES < 'Feb 01, 2006' 
and NAME in ('GOOG','MSFT','YHOO')

Candlestick Chart

Query Example

select DATES, HIGH_VAL as HIGH, LOW_VAL as LOW, OPEN_VAL as OPEN, 
CLOSE_VAL as CLOSE, VOLUME from 
http://datadirectory.net/Table/CHART_DB/STOCK_DATA where NAME='GOOG'