Skip to main content
Pentaho Documentation

Visualization types

Parent article

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.

Visualization IconDefinition and Use

Stream View

Available Field

Model View

Available Field

Layout Panel

Drop Zone Field

Table Icon 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 Icon 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  Icon 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 Chart 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  Icon 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 Icon 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  Icon

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  Icon

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 Icon 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 Icon 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 Icon 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 Icon

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 Icon

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 Icon 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 Icon 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

See also