Visualization Types

Last updated
Save as PDF

When inspecting your data, use the Visualization Selector to select a visualization type. The table below provides descriptions of the visualizations, corresponding drop zones in the Layout panel, and available field types for each viewing mode.

Definition and Use	Stream View Available Field	Model View Available Field	Layout Panel Drop Zone Field
Table: Presents data in rows and columns. Useful when inspecting and validating non-aggregated data.	Any	Not applicable in this view	Columns
Pivot table: Presents data in rows and columns summarized or broken down by selected fields. Useful when inspecting and validating across all of your data.	Not applicable in this view	Measure Non-measure Non-measure	Measures Rows Columns
Bar chart: Presents grouped data with horizontal bars in lengths proportional to the values that they represent. Useful for most data, best with a limited number of values to display.	Numeric Any Any	Measure Non-measure Non-measure	Horizontal Axis Vertical Axis Breakdown by
Stacked bar chart: Presents grouped data with horizontal bars broken down by another field with lengths proportional to the values represented and each bar representing a total. Useful for most data, best with a limited number of values to display.	Numeric Any Any	Measure Non-measure Non-measure	Horizontal Axis Vertical Axis Breakdown by
Column chart: Presents grouped data with vertical bars in lengths proportional to the values that they represent. Useful for most data, best with a limited number of values to display.	Numeric Any Any	Measure Non-measure Non-measure	Vertical Axis Horizontal Axis Breakdown by
Stacked column chart: Presents grouped data with vertical bars broken down by another field with lengths proportional to the values represented and each bar representing a total. Useful for most data, best with a limited number of values to display.	Numeric Any Any	Measure Non-measure Non-measure	Vertical Axis Horizontal Axis Breakdown by
Line chart: Presents data as a series of points connected by line segments. Useful for visualizing trends over time. In Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis. In Stream View, if a number field is used on the horizontal axis, the chart shows the numbers across that axis.	Numeric Any Any	Measure Non-measure Non-measure	Vertical Axis Horizontal Axis Breakdown by
Area chart: Presents an aggregate of the data. Useful for timelines and runs. Helps identify trends quickly by showing totals and how they are moving relative to each other. In Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis. In Stream View, if a number field is used on the horizontal axis, the chart shows the numbers across that axis.	Numeric Any Any	Measure Non-measure Non-measure	Vertical Axis Horizontal Axis Breakdown by
Pie chart: Presents data circularly, divided into slices, where a slice is proportional to the quantity of data it represents as part of the whole. Useful when presenting numerical worth relative to a whole group.	Numeric Any	Measure Non-measure	Measures Slices
Doughnut chart: Presents data circularly, divided into slices, where a slice is proportional to the quantity of data it represents as part of the whole. Useful when presenting numerical worth relative to a whole group.	Numeric Any	Measure Non-measure	Measures Slices
Sunburst chart: Presents data as a multilevel pie chart to represent the proportion of different values found at each level in a hierarchy, where each outward ring represents more detailed information relating to the inner ring to which it is connected. Fields containing empty slices are shown as gaps. Useful for numerical analysis of hierarchical data.	Not applicable in this view	Measure Non-measure	Measures Slices
Scatter chart: Presents data to show the relationship between two fields, where each point expresses values through its location and color. Useful for visualizing a large number of data points. In Stream View, if a date field is used on the horizontal or vertical axis, the chart shows a time series on that axis.	Numeric or date Numeric or date Any Any	Measure Measure Non-measure Any	Horizontal Axis Vertical Axis Dots Color
Bubble chart: Presents data as a set of disks plotted on horizontal and vertical axes, showing the intersection of the x and y values at each data point where each disk expresses values through its location, size, and color. Useful for timelines and when showing the categorical relationship between three sets of numerical measures. In Stream View, if a date field is used on the horizontal or vertical axis, the chart shows a time series on that axis.	Numeric or date Numeric or date Any Any Numeric	Measure Measure Non-measure Any Measure	Horizontal Axis Vertical Axis Dots Color Size
Heat Grid: Presents data as a matrix that uses color and square size to represent data values. Useful in identifying patterns of performance and for comparing categorical data using color.	Any Any Numeric Numeric	Non-measure Non-measure Measure Measure	Horizontal Axis Vertical Axis Color Size
Geo Map: Presents a geospatial summary of your data using size, color, and location. Useful for understanding data geographically. The non-measure field needs to be annotated with localization information (through auto-modeling or the Annotate Stream step). You must have a license from Google to use Google Maps with Pentaho software.	Not applicable in this view	Geography Measure Measure	Geography Color Size

Visualization Icon

Definition and Use

Stream View
Available Field

Model View Available Field

Layout Panel Drop Zone Field

Table: Presents data in rows and columns. Useful when inspecting and validating non-aggregated data.

Any

Not applicable in this view

Columns

Pivot table: Presents data in rows and columns summarized or broken down by selected fields. Useful when inspecting and validating across all of your data.

Not applicable in this view

Measure

Non-measure

Measures

Rows

Columns

Bar chart: Presents grouped data with horizontal bars in lengths proportional to the values that they represent. Useful for most data, best with a limited number of values to display.

Numeric

Any

Measure

Non-measure

Horizontal Axis

Vertical Axis

Breakdown by

Stacked bar chart: Presents grouped data with horizontal bars broken down by another field with lengths proportional to the values represented and each bar representing a total. Useful for most data, best with a limited number of values to display.

Numeric

Any

Measure

Non-measure

Horizontal Axis

Vertical Axis

Breakdown by

Column chart: Presents grouped data with vertical bars in lengths proportional to the values that they represent. Useful for most data, best with a limited number of values to display.

Numeric

Any

Measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Stacked column chart: Presents grouped data with vertical bars broken down by another field with lengths proportional to the values represented and each bar representing a total. Useful for most data, best with a limited number of values to display.

Numeric

Any

Measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Line chart: Presents data as a series of points connected by line segments. Useful for visualizing trends over time.

In Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis.

In Stream View, if a number field is used on the horizontal axis, the chart shows the numbers across that axis.

Numeric

Any

Measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Area chart: Presents an aggregate of the data. Useful for timelines and runs. Helps identify trends quickly by showing totals and how they are moving relative to each other.

In Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis.

In Stream View, if a number field is used on the horizontal axis, the chart shows the numbers across that axis.

Numeric

Any

Measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Pie chart: Presents data circularly, divided into slices, where a slice is proportional to the quantity of data it represents as part of the whole. Useful when presenting numerical worth relative to a whole group.

Numeric

Any

Measure

Non-measure

Measures

Slices

Doughnut chart: Presents data circularly, divided into slices, where a slice is proportional to the quantity of data it represents as part of the whole. Useful when presenting numerical worth relative to a whole group.

Numeric

Any

Measure

Non-measure

Measures

Slices

Sunburst chart: Presents data as a multilevel pie chart to represent the proportion of different values found at each level in a hierarchy, where each outward ring represents more detailed information relating to the inner ring to which it is connected. Fields containing empty slices are shown as gaps. Useful for numerical analysis of hierarchical data.

Not applicable in this view

Measure

Non-measure

Measures

Slices

Scatter chart: Presents data to show the relationship between two fields, where each point expresses values through its location and color. Useful for visualizing a large number of data points.

In Stream View, if a date field is used on the horizontal or vertical axis, the chart shows a time series on that axis.

Numeric or date

Any

Measure

Non-measure

Any

Horizontal Axis

Vertical Axis

Dots

Color

Bubble chart: Presents data as a set of disks plotted on horizontal and vertical axes, showing the intersection of the x and y values at each data point where each disk expresses values through its location, size, and color. Useful for timelines and when showing the categorical relationship between three sets of numerical measures.

In Stream View, if a date field is used on the horizontal or vertical axis, the chart shows a time series on that axis.

Numeric or date

Any

Numeric

Measure

Non-measure

Any

Measure

Horizontal Axis

Vertical Axis

Dots

Color

Size

Heat Grid: Presents data as a matrix that uses color and square size to represent data values. Useful in identifying patterns of performance and for comparing categorical data using color.

Any

Numeric

Non-measure

Measure

Horizontal Axis

Vertical Axis

Color

Size

Geo Map: Presents a geospatial summary of your data using size, color, and location. Useful for understanding data geographically. The non-measure field needs to be annotated with localization information (through auto-modeling or the Annotate Stream step). You must have a license from Google to use Google Maps with Pentaho software.

Not applicable in this view

Geography

Measure

Geography

Color

Size

See Also