Hitachi Vantara Pentaho Community Wiki
Child pages
  • The XY Dataset

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{scrollbar}

The XY Dataset

An XY Dataset plots pairs of values as points on the chart. The XY charts have two numeric axes.

...

PRODUCTLINE

MSRP

BUYPRICE

Classic Cars

101.15

46.53

Classic Cars

80.84

32.33

Classic Cars

118.28

69.78

Classic Cars

140.43

98.3

Classic Cars

107.08

62.11

...

 

 

Motorcycles

81.36

34.17

Motorcycles

102.05

56.13

Motorcycles

40.23

24.14

Motorcycles

99.89

66.92

...

 

 

Planes

49.66

32.77

Planes

74.03

36.27

Planes

80

54.4

Planes

118.65

59.33

Planes

99.72

68.8

...

 

 

Handing this dataset to a chart, the chart will plot the data by column by default. Here is a bar an xy line chart example:

Image Removed

Image Added

A Row-based Dataset Example

To plot the data by rows, you must add the by-row property to the action sequence component definition. (You can set this property in the Design Studio by checking the Chart Row Dimension checkbox.) Also, your data must be arranged in row format.

Code Block
XML
XML
<by-row>true</by-row>

Here is a bar chart example, with the same dataset plotted by rows:

Image Removed

Unlike the categorical dataset, arranging the dataset by rows does not change the plotting of the data on the chart. The exact same chart as above would be generated by this dataset:

Classic Cars

101.15

46.53

80.84

32.33

118.28

69.78

140.43

98.3

107.08

62.11

Motorcycles

81.36

34.17

102.05

56.13

40.23

24.14

99.89

66.92

 

 

Planes

49.66

32.77

74.03

36.27

80

54.4

118.65

59.33

99.72

68.8

...