Pivot Fields

Pivot Fields are essential to make data aggregation and summarization possible.

Field Types

There are 2 main types of fields, and all pivot fields fall into 1 of the 2 categories.

Measure Fields

Contains fields used as "measures", typically numeric values that are summarized by the engine.

Dimension Fields

Contain fields used as "dimensions", typically strings or dates that are used to break up data into groups.

These field categories are more or less defined by the data type of the value associated with the field. It is important to keep this in mind when manipulating field lists for a desired summary.

Field Lists

The PivotEngine has several field lists. Some are Dimension Fields and some are Measure fields.

  1. Value Fields
  2. Column Fields
  3. Row Fields
  4. Filter Fields

To create views, you need to add fields to these lists. The next topics will demonstrate how to do this.