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.

...

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

...