Skip to main content

Window Definition

  • 2 minutes to read

A window definition specifies a window that limits measure values used in a calculation. To learn more, see Window Calculations Overview.

Dashboard Item Window Definition

The following table lists window definitions in terms of the Pivot dashboard item. A calculation is performed using the Index function along the following directions.

Direction

Description

Example

Columns

A calculation is performed horizontally through Pivot columns.

In this example, a window is a combination of Country/Category dimensions.

Pivot_CalculateAlongColumns

Rows

A calculation is performed vertically through Pivot rows.

In this example, a window is a combination of Year/Quarter dimensions.

Pivot_CalculateAlongRows

Columns / Rows

A calculation is performed horizontally through Pivot columns, then rows.

In this example, a window is the entire pivot table.

Pivot_CalculateAlongColumnsRows

Rows / Columns

A calculation is performed vertically through Pivot rows, then columns.

In this example, a window is the entire pivot table.

Pivot_CalculateAlongRowsColumns

Columns within Groups

A calculation is performed horizontally through Pivot columns within groups.

In this example, a window is a combination of the Country/Category and Year dimensions.

Pivot_CalculateAlongColumns_Groups

Rows within Groups

A calculation is performed vertically through Pivot rows within groups.

In this example, a window is a combination of the Year/Quarter and Country dimensions.

Pivot_CalculateAlongRows_Groups

Columns / Rows within Groups

A calculation is performed horizontally through Pivot columns then rows within groups.

In this example, a window is a combination of Country/Year dimensions.

Pivot_CalculateAlongColumnsRows_Groups

Rows / Columns within Groups

A calculation is performed vertically through Pivot rows, then columns within groups.

In this example, a window is a combination of Country/Year dimensions.

Pivot_CalculateAlongRowsColumns_Groups

* Group - an area that is limited by a set of values corresponding to the bottommost partitioning dimensions.

Specific Window Definition

If necessary, you can manually specify the set of dimensions that fall into the window. These dimensions are called window dimensions.

For instance, the Index function is applied to measure values of the pivot table below using the OrderDate (Year) and Country window dimensions.

Pivot_CalculateAlongSpecificDimensions

The Specific Window Definition dialog allows you to do this.

SpecificWindowDefinitionDialog