| Wiki Markup |
|---|
{scrollbar}
h2. |
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 [ |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.
...
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 | 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:
...
