Skip to main content

CPM46

Charts and tables - Settings

General settings
18579991.png

The general settings allow you to:

  1. Sitch between the settings sections.

  2. Edit the title and switch the component type.

  3. See which dimensions and KPIs are currently configured.

  4. Jump to editing the dimension or KPI, apply a sorting on it, remove it or resort by drag and drop.

  5. Add new dimensions or KPIs.

  6. Change the sorting of the component.

  7. Apply advanced options:

    1. Hide and show the legend.

    2. Switch the layout to be vertical.

    3. Activate or deactivate tooltips.

    4. Display only distinct dimension entries.

    5. Exclude the component from being filtered by selections of other components.

    6. Disable selections on the component itself.

    7. Only on charts: Pin the scrollbar to the right.

  8. Limit how many data points are shown at once.

Diagram area and legend options
18579992.png

In the diagram area and legend options, you can:

  1. Set the title and the title's format options.

  2. Define the border options of the component: thickness, style, its color and its opacity.

  3. Activate a component background

  4. Activate and define the legend on charts.

  5. And set the legend format options.

Position line options (Charts only)
18579993.png

The position line will draw a line on the KPI axis after the definitions:

  1. Set a name and delete the position lines at the top left.

  2. Define a PQL statement set the label position, line thickness, line style, line color, opacity and if the value is shown on the label.

  3. Add a new position line.

Dimension axis (charts only)
18579994.png

The dimension axis will define how the axis for your dimensions will be displayed:

  1. Activate/deactivate the axis completely, set the line thickness, line style, color and opacity.

  2. Activate/deactivate the axis title.

  3. Hide and show the axis labels and configure their text format.

  4. Hide and show gridlines on the dimensions axis.

  5. Hide and show the ticklines on the dimension axis.

  6. Column chart only: Set the distance between the single bars.

Primary/secondary value axis
18579995.png

The primary and secondary value axis setting define how the KPI axis are visualized:

  1. Activate/deactivate the axis completely, set the line thickness, line style, color and opacity.

  2. Activate/deactivate the axis title.

  3. Hide and show the axis labels and configure their text format.

  4. Hide and show gridlines on the dimensions axis.

  5. Set the boundaries of values that are shown on the axis to automatic or manual range.

  6. Configure how the tick lines are displayed. Activate/deactivate them and define how many ticks are drawn.

Data series settings (tables)
18579996.png

The data series settings include all options on how the data returned from the engine will be interpreted:

  1. Give the data series a title which will be shown in the table header and define the PQL statements.

  2. KPIs only: You can activate shares in percentage. This will allow you to input a second PQL statement which is not split by the dimensions and the original KPI input will be divided by the result of the share in percentage statement. The share of a KPI as a percentage will be the result.

  3. Set the format options on the KPI or dimension.

  4. Define the text color with a default color and an optional color mapping to set a color threshold.

  5. Define the background color for the table cells with a default color and an optional color mapping to set a color threshold.

  6. Set the width of the column. By default this is the relative width, if horizontal scrolling is activated in the general settings, this is the number of pixels.

Data series settings (charts)
18579997.png

The data series options for charts follow the settings for tables above with the following differences:

  1. You can define on which axis the data series of a KPI is shown.

  2. A color palette can be set, which colors the single data points with the palette's colors according to the dimension.

  3. Data labels can be activated to be shown on top of the chart, where you can as well set the format, value and exact positioning.

Scatter plot options
18579998.png
18580000.png

The general options on the scatterplot are specific for the scatterplot component. All other advanced settings are shared with the other table and chart components.

  1. Set the title in the title input.

  2. The dimensions on the horizontal and vertical axis can be set individually.

  3. The the default series color with the default color picker or define a color mapping. The color mapping will be applied according to one of the dimensions.

  4. If you activate sorting, you can write a KPI or dimension that is used to sort your datapoints. Only the max. first 5000 values can and will be displayed in the chart.

  5. You can group the data points by a dimension or KPI. This grouping will be shown in the legend and the data points will be colored by the groups.

  6. In the advanced options you can choose to display the data labels, deactivate selections and deactivate that the component is filtered by selections.