en GPS Tab2 Data (charts) TBL

Owned by Stefanie Schröder (Unlicensed)
Last updated: Dec 22, 2021


Data Selection

Use the checkbox to specify which of the series should be visible in the chart.

Select the relevant measures to be displayed in the graphomate charts by clicking on the  symbol.

Small Multiples

To display so-called "small multiples" use the following options.:

Split Dimension

Determine which dimension should be used as the split dimension for the calculation of the small multiples.

  • None: no small multiples are calculated.
  • First Row: the first row dimension is used as the split dimension for the calculation of the small multiples.
  • First Column: the first column dimension is used as split dimension.

N Count

Defines the number of charts to be displayed before the 'Rest' position.

  • The N Small Multiples before the 'Rest' position are sorted in descending order according to their respective totals starting with the largest Small Multiple.
  • If the number N exceeds the number of existing members of the split dimension, no 'Rest' position can be formed. However, the descending sorting remains.
  • If the N Count is set to "0" or "none", the order of the small multiples corresponds to the order of the split dimension members from the data source.

Min Width [px]

Defines the minimum width of a small multiples chart.

Min Height [px]

Defines the minimum height of a small multiples chart.


N + Rest

Use this option to define the number of members (N + Rest) of a user-defined dimension. In the simplest case, this then corresponds to the number of category elements of a chart.

N + Rest Pop Up

You can define one configuration of N + rest for the graphomate charts:

  • Enable: Applies the N + Rest Confuration, when enabled.
  • Mode: Choose between top (Top) and bottom (Bottom).
  • Number n of top/bottom members: Define the number of top/bottom elements.
  • Target Dimension: The dimension for which the top/bottom members are to be determined - e. g. "Country".
  • Target Dimension Subset: Here you filter which measures or members of other dimensions (e. g. for implicit hierarchies) should affect the ranking .
  • Rest Member Name (optional): Sets a label for the rest member.
  • Description (optional): Defines a description for the set configuration.


Series

Styles

At this point you define the styling of a series. Use the Series Style pop-up to define the appearance of the data series, provided you do not use scenarios. Scenarios overwrite the Series Styles.

Import/Export

Copy this string to use Series Styles in other graphomate charts components.

Element Offset

The Element Offset parameter determines the displacement of the elements on the category axis relative to each other. This can be specified in percent or absolute in [px] using the switch. Negative values can also be used for displacement in the opposite direction.

Series Style Pop-Up

  • Color: Define the color using the colorpicker or enter a HEX code here.
  • Fill Type: The available Fill patterns are the following: filled(Filled), not filled (Empty), hatching down (Hatched Down), thick hatching down (Hatched Down Bold), hatching up (Hatched Up), thick hatching up (Hatched Up Bold), dotted (Dotted).
  • Shape: Refers to the pin heads or line points. The following shapes are available: circle, rectangle, rhomb, wedge, no symbol (none).
  • Width: Determines the width of the elements. This can be specified as a percentage of the category width or as an absolute value in [px].
  • Font Weight: Choose between normal or bold font size.

Width can only be applied to column and bar charts. 


Scenario Definition (formerly Data Types)

The list element contains all definitions of scenarios in this diagram. By clicking on the + symbol a new scenario is created. When hovering over a list element, a red trash can appears, which implies that a scenario has been deleted.

Scenarios CSS Export

Copy this string to use scenarios (formerly Data Types) in other graphomate charts components or to save them in the custom.css of the application.

Scenario Definition Pop-Up

  • Identifier: Assign a unique abbreviation for the scenario.
  • Color: Define the color using the colorpicker or enter a HEX code. 
  • Fill Type: The available Fill patterns are the following: filled(Filled), not filled (Empty), hatching down (Hatched Down), thick hatching down (Hatched Down Bold), hatching up (Hatched Up), thick hatching up (Hatched Up Bold), dotted (Dotted).
  • Shape: Refers to the pin heads or line points. The following shapes are available: circle, rectangle, rhomb, wedge, no symbol (none).
  • Width: Determines the width of the elements. This can be specified as a percentage of the category width or as an absolute value in [px].
  • Font Weight: Choose between normal or bold font size.

Scenario Assignment

The scenarios can be assigned in two ways:

  1. Scenario per element of a series (Scenarios 1, Scenarios 2 etc.)
    1. A field represents one element of the selected series. As soon as the abbreviation of the scenario is entered in a field, the series is extended by one field.
    2. Alternatively, you can click on the csv button to enter the input using a comma-separated character string (Example: AC,AC,AC,FC,FC,BU).
  2. Scenarios by Series
    1. A line corresponds to a series. Enter a data abbreviation that is used for the entire series.
    2. The + symbol can be used to assign further fields (or series) with a data abbreviation.
  3. Scenarios by Dataselection
    1. Define which data is assigned to which scenario.

The scenarios are applied in the following order of precedence:

  • Scenarios per element of a series
  • Scenarios by Series vor
  • Scenarios by Dataselection

Scenarios in Axis

If the checkbox is activated, the scenarios of the first data series are displayed in the axes if Axis Thickness is greater than or equal to 3 [px].

Scenario Legend

If the checkbox is activated, a legend with the respective scenarios is displayed in the diagram. These can be changed later directly in the diagram by the user via a dropdown menu.

The Scenario Legend is only functional in connection with the property "Scenarios by Series". For compatibility reasons it is recommended to use the scripting function getSelectedMember() only with the Multi Selection property disabled.

Scenarios in Deviations

If the checkbox is activated, the scenarios are shown in the deviations.

Scenarios by Dataselection Pop Up

This property determines which data is assigned to which scenario.

Each configuration has the following properties:

  • Scenario Id: The ID of the scenario to be used. A scenario ID used here, has to be defined in the scenario definition.
  • Filter: The selected scenario is assigned for each dimension member that is selected here using the  sign.
  • Description: Short name describing the configuration to be recognizable.

Selection

Multi Selection

This option allows multiple selection of chart elements. Use the left click to select an element. For the selection of several elements use the CTRL key additionally. As soon as one or more elements are selected, the remaining elements are displayed with reduced opacity. You determine the opacity with the option Fade Out Opacity.

Furthermore, the selection can be deselected by clicking on already selected elements.

The selection influences the scripting function .getSelectedMember() and .getSelectedMembers().

Fade Out Opacity

This value determines to what extent elements of the chart that are not highlighted should be hidden. The value starts at 0.0 (completely hidden) and ranges up to 1.0 (completely visible).