Visualization types

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

Note: Does 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.

Note: Does 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.

Note: In 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.

Note: In 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.

Note: Does 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.

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

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

Note: Does not apply in this view.

Geography

Measure

Measure

Geography

Color

Size