The setTypedData, setTypedDBQuery, and setTypedResultSet methods each take dataType as a parameter. The table below lists the supported values for dataType.
|
dataType |
Description |
Graph Types |
|
Data series are in rows and data categories are in columns. This is a legacy PopChart® data format. |
All | |
|
Data is stored primarily in two columns: Column 1 contains item names, and column 2 contains values. Columns 3 and above are available for meta data related to drilldown and hover. |
Bar, pie, pareto, line, step, radar, heat-map | |
|
Data is stored primarily in three columns: Column 1 contains group names, column 2 contains item names, and column 3 contains values. Columns 4 and above are available for meta data related to drilldown and hover text. |
Bar, stacked bar, pareto, line, step, radar, heat-map, line-bar combo, stacked line-bar combo | |
|
Data is stored primarily in three columns: Column 1 contains line names, column 2 contains X values, and column 3 contains Y values. Columns 4 and higher are available for meta data related to drilldown and hover text. |
XY Line, XY Scatter, TimeY Line, | |
|
Data is stored primarily in four columns: Column 1 contains line names, column 2 contains X values, column 3 contains Y values, and column 4 contains bubble values. Columns 5 and higher are available for meta data related to drilldown and hover text. |
XY Bubble, | |
|
Data is stored primarily in three columns: Column 1 contains date and/or time, column 2 contains high values, and column 3 contains low values. Columns 4 and higher are available for meta data related to drilldown and hover text. |
Stock HighLow | |
|
Data is stored primarily in four columns: Column 1 contains date and/or time, column 2 contains high values, column 3 contains low values, and column 4 contains close values. Columns 5 and higher are available for meta data related to drilldown and hover text. |
Stock HLC | |
|
Data is stored primarily in five columns: Column 1 contains date and/or time, column 2 contains high values, column 3 contains low values, column 4 contains open values, and column 5 contains close values. Columns 6 and higher are available for meta data related to drilldown and hover text. |
Stock HLOC, | |
|
Data is stored primarily in six columns: Column 1 contains item names, column 2 contains low values, column 3 contains Q1 values, column 4 contains median values, and column 5 contains Q3 values, and column 6 contains high values. Columns 7 and above are available for meta data related to drilldown and hover text. |
Box-plot | |
|
Data is stored primarily in six columns: Column 1 contains item names, column 2 contains low values, column 3 contains Q1 values, column 4 contains median values, and column 5 contains Q3 values, and column 6 contains high values. Columns 7 and higher contain outliers. |
Box-plot with Outliers |
The following sections provide samples of well-formed data tables for each supported dataType value.
This parameter value forces typed methods to function as legacy untyped methods. For example, calling setTypedData with dataType = legacy is equivalent to calling setData.
When dataType = item-value, data tables should be organized as in the following example:
|
Item |
Value |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
100 |
www.corda.com |
myHoverText |
Other Text |
|
item 2 |
200 |
|
|
|
|
item 3 |
300 |
|
|
|
When dataType = group-item-value, data tables should be organized as in the following example:
|
Group |
Item |
Value |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
group 1 |
item 1 |
100 |
www.corda.com |
myHoverText |
Other Text |
|
group 1 |
item 2 |
200 |
|
|
|
|
group 1 |
item 3 |
300 |
|
|
|
|
group 2 |
item 1 |
400 |
|
|
|
|
group 2 |
item 2 |
500 |
|
|
|
|
group 2 |
item 3 |
600 |
|
|
|
|
group 3 |
item 1 |
700 |
|
|
|
|
group 3 |
item 2 |
800 |
|
|
|
|
group 3 |
item 3 |
900 |
|
|
|
When dataType = line-xyt, data tables should be organized as in the following example:
|
Item |
x |
y |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
1 |
2 |
www.corda.com |
myHoverText |
Other Text |
|
item 1 |
3 |
4 |
|
|
|
|
item 1 |
5 |
6 |
|
|
|
|
item 2 |
7 |
8 |
|
|
|
|
item 2 |
9 |
10 |
|
|
|
|
item 2 |
11 |
12 |
|
|
|
|
item 3 |
13 |
14 |
|
|
|
|
item 3 |
15 |
16 |
|
|
|
|
item 3 |
17 |
18 |
|
|
|
When dataType = line-xytbubble, data tables should be organized as in the following example:
|
Item |
x |
y |
bubble |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
1 |
2 |
3 |
www.corda.com |
myHoverText |
Other Text |
|
item 1 |
4 |
5 |
6 |
|
|
|
|
item 1 |
7 |
8 |
9 |
|
|
|
|
item 2 |
10 |
11 |
12 |
|
|
|
|
item 2 |
13 |
14 |
15 |
|
|
|
|
item 2 |
16 |
17 |
18 |
|
|
|
|
item 3 |
19 |
20 |
21 |
|
|
|
|
item 3 |
22 |
23 |
24 |
|
|
|
|
item 3 |
25 |
26 |
27 |
|
|
|
When dataType = stock-hl, data tables should be organized as in the following example:
|
Item |
high |
low |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
3 |
2 |
www.corda.com |
myHoverText |
Other Text |
|
item 2 |
9 |
7 |
|
|
|
|
item 3 |
5 |
1 |
|
|
|
When dataType = stock-hlc, data tables should be organized as in the following example:
|
Item |
high |
low |
close |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
9 |
1 |
7 |
www.corda.com |
myHoverText |
Other Text |
|
item 2 |
8 |
2 |
5 |
|
|
|
|
item 3 |
7 |
3 |
5 |
|
|
|
When dataType = stock-hloc, data tables should be organized as in the following example:
|
Item |
high |
low |
open |
close |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
9 |
1 |
5 |
7 |
www.corda.com |
myHoverText |
Other Text |
|
item 2 |
8 |
2 |
5 |
5 |
|
|
|
|
item 3 |
7 |
3 |
7 |
5 |
|
|
|
When dataType = boxplot, data tables should be organized as in the following example:
|
Item |
low |
q1 |
median |
q3 |
high |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
1 |
2 |
3 |
4 |
5 |
www.corda.com |
myHoverText |
Other Text |
|
item 2 |
2 |
3 |
4 |
5 |
6 |
|
|
|
|
item 3 |
3 |
4 |
5 |
6 |
7 |
|
|
|
When dataType = boxplot-outliers, data tables should be organized as in the following example:
|
Item |
low |
q1 |
median |
q3 |
high |
outlier 1 |
outlier 2 |
Meta-data1 |
Meta-data2 |
Meta-data3 |
|
item 1 |
2 |
3 |
4 |
5 |
6 |
11 |
|
www.corda.com |
myHoverText |
Other Text |
|
item 2 |
3 |
4 |
5 |
6 |
7 |
|
|
|
|
|
|
item 3 |
4 |
5 |
6 |
7 |
8 |
1 |
14 |
|
|
|