Settings
The Report Parameters Settings define the look & feel and behavior of a report. On the screenshot below you can see the parameters numbers. These numbers refer to the parameters as displayed in the Parameters table. Next to these parameters there are also /wiki/spaces/CXO/pages/2806776440
Every parameter setting displayed in the table below occurs 6 times, so all parameters settigs as described configure 1 of the 6 charts.
Parameters
ParameterExplanation regarding the General Settings, Point of View & Dimensions and Comments Settings can be found in Report Settings.
Content Settings
Settings | Description | Mandatory | |||
|---|---|---|---|---|---|
1. Chart# Bars List | A Lists that defines the bars part of the chart. Check the Chart Bar Style article for formatting options. | No | |||
2. Chart# Lines List | A Lists that defines the lines of the chart. Check the Chart Line Style, Chart Dash Style and Chart Shape Style articles for formatting options. | No | |||
3. Chart# Title | Enter a title for the chart (Optional). | No | 4. Chart# Time Series | A list that defines the items for the X Axis. This list typically exists of time dimensions like year and period, but other dimensions can also be used. | Yes5. Chart# |
Labels, Formats and Colors
| Settings | Description | Mandatory |
|---|---|---|
| Chart# Title | ||
Chart# Y Axis Title | The title to be displayed vertically next to the y axis | No6. Chart# |
Chart# Right Y Axis Title | The title to be displayed vertically next to the second y axis on the right of the chart | No |
| Chart# Axis Labels Format | This settings allows you to chosse the Labels format | Yes |
| Chart# Axis Labels Postfix | ||
| Chart# Data Label Format | The format of the data label | |
Chart# Show Every N label | This setting allows you to show every n parameter. This could help make a chart more legible by showing less labels | Yes |
Chart# Labels Intersect Action | This setting determines what action should be taken when Labels intersect: apply multiple rows, rotate or wrap | Yes |
Chart# Rotate Labels | This setting allows you to rotate the labels clockwise, counterclockwise, horizontally or vertically | Yes |
Other
| Settings | Description | Mandatory | |||
|---|---|---|---|---|---|
| Chart# Use Dual Y-Axes | Set to Yes if you want a second Y-axis for the Line-chart (in case Bars and Lines are combined in 1 axis frame) | Yes | |||
| Chart# Zoom | The zoom setting defines if the chart y axis should be zoomed. If you select no the y axis will always start at 0 or lower | Yes | |||
| Chart# | Right Y Axis TitleThe title to be displayed vertically next to the second y axis on the right of the chart | No | 9. Chart# Legend Position | Choose the position of the chart legend (e.g. Bottom, Right, etc.) | No |
| Chart# Legend Size | Specify the legend size which is the percentage of the chart size. This setting will be ignored if Legend Position is set to Do not show | No | 11.|||
| Chart# | Title FormatA list of /wiki/spaces/CXO/pages/2806776298 to be used for the chart title | Yes | |||
12. Chart# Axis Title Format | A list of /wiki/spaces/CXO/pages/2806776298 to be used for the Axis title | Yes | |||
13. Chart# Show Every N label | This parameter allows you to show every n parameter. This could help make a chart more legible by showing less labels | Yes | |||
14. Chart# Labels Intersect Action | This parameter determines what action should be taken when Labels intersect: apply multiple rows, rotate or wrap | Yes | |||
15. Chart# Rotate Labels | This parameter allows you to rotate the labels clockwise, counterclockwise, horizontally or vertically | Yes | |||
16. Chart# Orientation | This parameter allows you to rotate the chart and make the display of the chart either Vertical or HorizontalOrientation | This parameter allows you to rotate the chart and make the display of the chart either Vertical or Horizontal | Yes |
Common
| Settings | Description | Mandatory |
|---|---|---|
| Scale | This defines the scaling used in the report. Options are: Unchanged (no scaling), Thousands, Millions, Billions, Percentage. The last option multiplies the amount by 100 to show for example an amount of 0.75 from the source as '75%' in the CXO-Cockpit. The scale setting is the default for all data in the report, but can be overruled by a specific (non-default) scaling in the Member List. | Yes |
| Precision | This defines the number of decimals used for presenting the number. Options are 0-12. Similar to the Scale setting, the Precision setting is the default for all data in the report, but can be overruled by a specific (not -1) precision in the Member list. | Yes |
| Frequency | This defines the frequency of the report. Options are M (Monthly), Q (Quarterly) , Y (Yearly) or Any (user select). The frequency setting also impacts the options in the Point of View: Upon selecting M, the user can only select the Months. If you select Q, the user can only select Quarters. Selecting Any (user select) will allow the user to select either a Month, Quarter or Year from the Point Of View as required. | Yes |
| Palette | Color Palette allows you to customize colors displayed in a report | Yes |
| Left Footer Text | Enter a text that will appear in the lower left part of the report. This is dynamic label where you can use dimension values like [VAL] or one or more of the listed static indicators. | Yes |
See Also
Functional end-user description of template:Multiple Bars and Lines