...
| Field | Description | ||||
|---|---|---|---|---|---|
| Pivot Column Source | The pivot column source determines how the the values that are converted to Pivot Columns are generated:
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.
or
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 | This 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 Attribute | If 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. |
...