Versions Compared

Old Version 3

changes.mady.by.user Gary Parden

Saved on

compared with

New Version 4

changes.mady.by.user Gary Parden

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 value 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.

The 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', 'Jan'], [ '20150201', 'Jan'], [ '20150301', 'Jan'] ]

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', 'Jan'], [ '20150201', 'Jan'], [ '20150301', 'Jan'] ]

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 Attributes The row attributes will be displayed on the left of the view.
Maximum Pivot Columns 

Column attribute

 
Value Attribute 
Label Attribute 

...