Versions Compared

Old Version 7

changes.mady.by.user Craig Strangwick (Unlicensed)

Saved on

compared with

New Version 8

changes.mady.by.user Craig Strangwick (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldDescription
Pivot Column Source

The pivot column source determines how the the values that are converted to Pivot Columns are generated:

View Data

The pivot column values are read from the Column Attribute in the data being viewed.

If the Label Attribute is specified, the label values corresponding to the value attribute values are used as pivot column headers.

The is the simplest way to derive the pivot column values, but does not allow any control of the order of values, or the ability to handle missing values e.g. when generating standard reports

Expression

The pivot column values are the result of an expression.

If no labels are provided, they are derived from the pivot values using the formatting options set on the Column attribute.

Pivot Column Expr

If Pivot Column Source == Expression, this expression must return either a list of values or a list of pairs of values (the values and corresponding labels). E.g.

['20150101', '20150201', '20150301']

or

[ [ '20150101', 'January 2015'], [ '20150201', 'February 2015'], [ '20150301', 'MArch March 2015'] ]

The expression can refer to any lookup pipe that is an input to the Stream being viewed.

If no labels are provided, they are derived from the pivot values using the formatting options set on the Column attribute.

Row AttributesThe row attributes will be displayed on the left of the view.
Maximum Pivot ColumnsThis is the maximum number of pivot columns that can be displayed. If this is blank, the system-wide default in System Configuration is used.

Column attribute

Values in the Column Attribute are mapped to separate columns in the resulting view.

The formatting options on the attribute (decimal places, date/time format) can be used to automatically generate column headers corresponding to Column Attribute values.

Value Attribute

When the view is displayed, the value in this Value Attribute will be displayed in the column corresponding to the value in the Column Attribute.

A Pivot View is not automatically grouped. To make this a grouped view, you should set the value attribute's aggregate function (e.g. to SUM).

Label AttributeIf Pivot Column Source == View Data, this attribute provides the pivot column labels corresponding to the column values. In most cases, the number of values for the label attribute, should be exactly the same as the number of values for the column attribute.

...