Data cubes

A data cube is the basic unit of representation of data within Pivot.

In the data cube you can freely explore the various dimensions and measures in your data.

Shown below is a heatmap visualization from a data cube for Wikipedia edits data, using filters for Latest Day and Language not English, with splits on Language and Time by Hour. We'll discuss filters and splits in more detail here.

Cube view heatmap


Filters let you focus on a specific part of your data. It could be a period or time, a certain country or a number of countries, or any other segment of a dimension in your data.

The filters live in the filter bar.

Cube view filter tile

To add a filter, drag a dimension from the dimension panel to the filter bar, or click a dimension and select Filter.

Cube view dimension preview menu

Alternatively click on the + button in the filter bar.

Cube view filter add

You can also add filter by clicking (in some cases also dragging) a segment on the main visualization and pressing Select.

Cube view bar chart highlight menu

There are specific filter controls that are tailored specifically to the type of data being filtered.

Time filters

You can filter on time and select a filter that is relative to the most recent time of the data.

Cube view filter time-type-relative

You can also select a specific time range.

Cube view filter time-type-specific

Or select a multitude of disjoint time ranges.

Cube view filter time-type-multi

String filters

You can select one or more strings to filter on. These can be selected with the aid of a search.

Cube view filter string

There are other possible filter types that can be used to filter on string data.

Cube view filter string options

You can exclude certain dimensions or select only the values that contain a certain text (or match a regular expression).

Number filters

You can filter on a number range.

Cube view filter number


Use splits to visually compare several segments in your data. For example, compare different hours of the day to one another, or different countries to one another. The splits live in the split bar.

Cube view split tile

To add a split, drag a dimension from the dimension panel to the split bar, or click a dimension and select "Split". To replace all the existing splits, drag a dimension to the visualization panel.

You can also add a split from the + button in the split bar.

Cube view aplit add

The splits you select will affect the shown visualization.

Cube view split string

Exploring data cubes

Find root causes

Contextual exploration

Contextual navigation