Visualization types

Last updated
Save as PDF

When inspecting your data, use the Visualization Selector to select a visualization type. The table below provides guidelines for use of the visualization types and correlates, depending on the chosen view, the available field types in the dataset to their respective drop zones in the Layout panel.

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	NoteDoes not apply 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.	NoteDoes not apply in this view.	Measure Non-measure Non-measure	Measures Rows Columns
Bar: 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: 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: 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: 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: Presents data as a series of points connected by line segments. Useful for visualizing trends over time. NoteIn Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis; 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: 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. NoteIn Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis; 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: 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: 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: 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.	NoteDoes not apply in this view.	Measure Non-measure	Measures Slices
Scatter: 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. NoteIn 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: 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. NoteIn 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.	NoteDoes not apply 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

NoteDoes not apply 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.

NoteDoes not apply in this view.

Measure

Non-measure

Measures

Rows

Columns

Bar: 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: 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: 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: 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: Presents data as a series of points connected by line segments. Useful for visualizing trends over time.

NoteIn Stream View, if a date field is used on the horizontal axis, the chart shows a time series on that axis; 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: 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.

Numeric

Any

Measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Pie: 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: 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: 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.

NoteDoes not apply in this view.

Measure

Non-measure

Measures

Slices

Scatter: 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.

NoteIn 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: 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.

NoteIn 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.

NoteDoes not apply in this view.

Geography

Measure

Geography

Color

Size

See also