Pivot slide

The Pivot Table is a slide type available to add to any pack

This functionality will be familiar to users with experience using MS Excel or other similar applications

It is a data summary table that provides aggregate data statistics grouped together in meaningful ways

  1. Columns
  2. Rows
  3. Values

When a pivot table is first added, the default view is to show count of records by depth as below

In common with the Bar and Heatmap function in Worksheet, the color palette applied is a default one that cannot be amended

By default, any value displayed in a cell is an aggregate value for a particular column and row property bucket combination, e.g. total headcount at depth 6 of hierarchy is 406

image

Columns

To add columns to the Pivot view:

  1. Select the Columns Add Property button
  2. Select the required property from the list
  3. Property will display as columns

image

It is possible to add more than one property as a column

image

In common with many other slide types these properties can be dragged and dropped to reorder them on the slide

image

Rows

Properties may be added as rows using the same process as columns

  1. Select the Rows Add Property button
  2. Select the required property from the list
  3. Additional row properties will show initially collapsed under first property
  4. The level control will also be set at 1 level initially

image

  1. Levels may be expanded individually using the chevron icon
  2. All levels can be controlled by using the level control
  3. Row properties may be deleted using the X shown on the property

image

Values

To add values to be pivoted, you can:

  1. Select the Add Property button
  2. Select the required property from the list
  3. Select the aggregate value option to be displayed

image

For measure properties you can choose from the following options:

  • Average (AVG) The average of the grouped data values
  • Sum (SUM) The sum of the grouped data values
  • Minimum (MIN) The lowest value in the grouped data
  • Maximum (MAX) The highest value in the grouped data
  • Range (RNG) The delta value between min and max in the grouped data
  • Count (CNT) The count of non-blank nodes in the grouped data
  • Bucket Count (CNTD) Provides a distinct count of property values for nodes in grouped data

For dimension properties the options are limited to:

  • Count (CNT) The count of non-blank nodes in the grouped data
  • Bucket Count (CNTD) Provides a distinct count of property values for nodes in grouped data

Pivot Columns menu

In common with the Worksheet slide, columns in Pivot slides also have the more options menu accessed from the 3 dots in the column header

image

Select the links below for more details on:

results matching ""

    No results matching ""

    results matching ""

      No results matching ""