Skip to main content
Pentaho Documentation

Visualization Types

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. 

Visualization Icon Definition and Use

Stream View
Available Field

Model View  Available Field 

Layout Panel  Drop Zone Field

table.png

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

Any

Not applicable in this view

Columns

pivot table.png

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

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

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

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

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 graph.png

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.

 

Numeric

Any

Any

Measure

Non-measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Area graph.png

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.

Numeric

Any

Any

Measure

Non-measure

Non-measure

Vertical Axis

Horizontal Axis

Breakdown by

Pie chart.png

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

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

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

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

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 chart.png

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

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

See Also