Skip to content

Pivot Grid

Screenshot A Pivot Grid with user tools showing

Displays a Pivot/OLAP control data set

Basics

Screenshot

Data Source
Pivot Query: the source data for the grid
Focus
A View State Parameter Used for linking components
Drilldown

When checked, enables Drilldown.

Screenshot
Drilling down

Show Tools

Show user controls: Drilldown, filtering and download

Screenshot

Animate
Offer smoothing animation on drilldown versus a 'hard' drilldown.
Multiple Drilldown
Supports multiple OLAP drilldown paths versus the default single drilldown.
Expand All

All OLAP elements are expanded on Pivot Grid load

Screenshot Two expanded OLAP pivots

Sort
Sort Column and Sort Order define the default sort order, ascending or descending, for the selected data source column on load.
Scroll Value
Required for PDF Creation

Breakdown columns

Appearance of columns from the Pivot Query

Screenshot

Display Name
A name for the column
Tooltip
Text description active on rollover of column header
Min Width (px)
Min Width (px) is a protective fall back if _Width (relative) is unable to render columns correctly
Width (relative)

Column width relative to total width of Pivot Grid. Scale relates to the values of each column; for example, a column of Width (relative) of 20, in a Pivot Grid using column widths of 20, 10, 5, 1 will scale at a column width of 55% (i.e. 20/(20+10+5+1))

Relative columns scale according to the browser size.

Text Align
center, left, right
Sortable

When checked, shows sort controls in column headers:

Screenshot

Format
Screenshot
Formatted columns
Precision and Hide Trailing Zeroes
Number of decimal places used to display numeric, and whether to show trailing zeroes
Currency Symbol
Text representation of currency symbol in data column; select from $, £ or

Screenshot
Currency columns with prefixed symbols

Date Format and Time Format
Screenshot
Timestamps with a DateTime format
Percentage Color

A color: where Format is Percentage, displays a mini bar in the range 0-100%

Screenshot
Percentage values with mini bars

View State Parameter

Percentage Color can be a View State Parameter: roll over the end of input bar until until the eye icon appears, click the icon to assign the view state.

Template
Apply HTML customizations with Handlebar helpers; for example:
<font color="blue">{{column name}}</font>

where {{column name}} is the reference name for the column from the data source

Templates

Aggregate columns

Screenshot

Dependent columns from the pivot query

Data Field Name
A Data Source column
Display Name
for the column
Tooltip
Rollover text description of header
Min Width (px)
Min Width (px) is a protective fall back if _Width (relative) is unable to render columns correctly
Width (relative)
Relative measure to total width of Pivot Grid. Scale is contigent on the values of each column; for example, a column of Width (relative) of 20, in a Pivot Grid using column widths of 20,10,5,1 will scale at a column width of 55% (i.e. 20/(20+10+5+1)) Columns will scale according to the viewable browser area.
Text Align
Alignment of values inside Pivot Grid: left, center, right
Sortable
When checked, shows sort controls in column headers:
Format
Formatting for the data in the column
Precision
Where data are numeric, the number of decimal places to display
Hide Trailing Zeroes
Removes trailing zeroes from displayed values
Currency Symbol
Screenshot
Values with prefixed currency symbols
Date Format
Time Format

A Date format and a Time format: where Format is Date, Time, or DateTime the display format is combined from Date Format and Time Format

Screenshot Screenshot
A DateTime column with both a Date Format and a Time Format

Highlighting negatives

When Highlight Negative is checked, negative values will be shown in Negative Color

Screenshot Pivot Grid with negative numbers highlighted

Highlighting changes
When Highlight Changes is checked, cells will highlight green (for higher than previous value) or red (for lower than previous value). Used for streaming or polling data; the persistence of the highlight is controlled by Highlight Change Duration
Show arrows on Change
When checked, up and down arrows will appear when value is greater or less than previous value. Used for streaming or polling data.
Highlighting highs, lows and ranges

Checkboxes Highlight Min Value, Highlight Max Value, and Range Highlight apply colors to highlight values:

Screenshot Screenshot Screenshot
Columns with Min Value Color, Max Value Color, and Range Color applied

Percentage Color

A color, used for mini-bars when Format is Percentage

Screenshot

Colors can be View State Parameters

Min Value Color, Max Value Color, Range Color, and Percentage Color can be View State Parameters.

Footer

Adds a column sub-total value for weighted average, average, count, sum or none

Screenshot

Footer Weight
Applies a weighting to current column by selected data source variable. For this to be enabled, Footer must be set to weighted average.

Selection and routing

Screenshot

With Enable Row Selection, values from the selected grid row are mapped to a View State Parameter.

Viewstate routing

Action

Actions

Highlight rules

Highlight Rules

File export

The content of a Pivot Grid can be exported as a .csv or .xls file

Show Export Csv Button
Show Export Excel Button
When checked, show a button to export the grid data as a CSV file and/or an Excel spreadsheet.
Filename
A filename for the exported file, or a View State Parameter which can be linked to a Text Input to allow user define their own filename.

Style

Style for common settings