...
| Field | Description | ||||
|---|---|---|---|---|---|
| Pivot Column Source | This controls how the field given the role Pivot Column will be used to generate columns in the pivot table. Choose from one of:
| ||||
| 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.
HELPDEVTODO: how does these map to values in the Pivot Column attribute? Ask GP or
The expression can refer to any lookup pipe that is an input to the parent stream of the view. If no labels are provided, the values returned are formatted based on the formatting rules of the Pivot Column field. | ||||
| 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. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following fields only apply for charts of type Line Chart (time). These apply to the horizontal axis, which in this case is a time series:
| Field | Description |
|---|---|
| Primary Axis Unit | Units for date display along the horizontal axis. Choose a value from the drop down list. Note, however, that only as many values will be displayed as can comfortably be fitted in the space available. |
| Primary Axis Format | Choose a format to display dates along the primary horizontal axis. |
| Secondary Axis Unit | Units for an optional, second date display along the horizontal axis. This might be used, for example, to create a graph where the months are shown along the primary horizontal axis (Primary Axis Unit = 'Month', Primary Axis Format = 'Jan, Feb') and the years are shown along a line below this, along the secondary horizontal axis (Secondary Axis Unit = 'Year', Secondary Axis Format = 'Four digit year'). |
| Secondary Axis Format | Choose a format to display dates along the secondary horizontal axis, if this is being used. |
Dial charts
HELPDEVTODO: dial charts no in form at all
The following fields apply only to dial charts:
| Field | Description |
|---|---|
| Major Tick Increment | The incremental values at which major tick marks should be shown. Do not set too low for the minimum/maximum values specified otherwise there will be too many major ticks. |
| Minor Tick Count | The number of tick marks between each major tick. |
| First Band Colour | The colour of the first segment on the three coloured arc indicating different regions of the dial. |
| Second Band Colour | The colour of the second segment on the three coloured arc indicating different regions of the dial. |
| Third Band Colour | The colour of the third segment on the three coloured arc indicating different regions of the dial. |
| First Threshold Value | The value at which the first band colour changes to the second band colour. |
| Second Threshold Value | The value at which the second band colour changes to the third band colour. |
| Dial Style | Arc or Circular. |
Chart attributes
The best way to configure the chart attributes is to add it to a dashboard, and then use the graphical chart builder in design mode to set the attributes to create the chart you need.
...