| Wiki Markup |
|---|
{scrollbar}
----
h3. The XYZ Dataset
An XYZ Dataset is currently only used for bubble charts. This dataset plots on a chart with two numeric axes. The way this dataset is currently implemented, each series has three numeric values - the first two are the X and Y values which denote a point on the chart plot area. The third value, the Z value, determines the size of the circle that is drawn around the XY point.
As you can see, this limits the bubble chart to one point per series. This implementation is very limited in what you can do with a bubble chart. we intend to expand the data processing of the bubble chart in the near future.
{note:title=Passing Multiple Rows Per Series Bug}
There is an [open issue|http://jira.pentaho.org/browse/BISERVER-353] (as of Sept. 2007) on bubble charts where if you pass multiple rows with the same series name to a bubble chart, only the last row for that series is rendered. This is due to the limiting code in the data loader portion of this chart implementation.
{note}
Column and row based datasets look the same for an XYZ dataset. Each row is expected to have four columns. Each row is assumed to represent one data point on the chart, ordered by the series name and domain value. The first column's values contain the name of the series. The second column is numeric, containing the domain value of the data point. The third column is numeric, containing the range value of the data point. The fourth column is numeric, representing the value to use in the algorithm that determines the size of the bubble drawn around the data point.
h3. A Dataset Example
Here is a query and dataset from the Pentaho sample data that demonstrates an XYZ dataset:
{code:SQL}
|
The XYZ Dataset
An XYZ Dataset is currently only used for bubble charts. This dataset plots on a chart with two numeric axes. The way this dataset is currently implemented, each series has three numeric values - the first two are the X and Y values which denote a point on the chart plot area. The third value, the Z value, determines the size of the circle that is drawn around the XY point.
As you can see, this limits the bubble chart to one point per series. This implementation is very limited in what you can do with a bubble chart. we intend to expand the data processing of the bubble chart in the near future.
| Note | ||
|---|---|---|
| ||
There is an open issue (as of Sept. 2007) on bubble charts where if you pass multiple rows with the same series name to a bubble chart, only the last row for that series is rendered. This is due to the limiting code in the data loader portion of this chart implementation. |
Column and row based datasets look the same for an XYZ dataset. Each row is expected to have four columns. Each row is assumed to represent one data point on the chart, ordered by the series name and domain value. The first column's values contain the name of the series. The second column is numeric, containing the domain value of the data point. The third column is numeric, containing the range value of the data point. The fourth column is numeric, representing the value to use in the algorithm that determines the size of the bubble drawn around the data point.
A Dataset Example
Here is a query and dataset from the Pentaho sample data that demonstrates an XYZ dataset:
| Code Block | ||||
|---|---|---|---|---|
| ||||
select department, sum(actual) as actual, sum(budget) as budget, sum(variance) as variance from QUADRANT_ACTUALS WHERE NOT department like 'Prof%' group by department {code} This query results in the following dataset: || DEPARTMENT || ACTUAL || BUDGET || VARIANCE || | Sales | |
This query results in the following dataset:
DEPARTMENT | ACTUAL | BUDGET | VARIANCE |
|---|---|---|---|
Sales | 11,168,773 |
...
10,973,392 |
...
-195,381 |
...
Executive Management | 6,299,022 |
...
6,494,166 |
...
195,144 |
...
Finance | 12,224,220 |
...
12,087,406 |
...
-136,814 |
...
Human Resource | 13,075,463 |
...
12,989,341 |
...
-86,122 |
...
Marketing & Communication | 13,910,753 |
...
13,770,267 |
...
-140,486 |
...
Product Development | 10,644,102 |
...
10,786,611 |
...
142,509 |
...
Handing
...
this
...
dataset
...
to
...
a
...
chart,
...
the
...
chart
...
will
...
plot
...
the
...
data
...
by
...
column
...
by
...
default.
...
Here
...
is
...
an
...
example:
...
