en GPS Tab1 Start (charts) TBL

Owned by Stefanie Schröder (Unlicensed)
Last updated: Jul 09, 2024 by Alexander Widdecke


Data Binding

Worksheet Data Source

Select the required data source (worksheet name) from the list.

Series Dimension

Select the dimension to be displayed as a series.

Scenario Dimension

If you have a dimension in which the scenarios of the data points are defined, select it here.

Sorting

Click in the line to create a configuration. Click again to open the dialog.

Dimension

Select the dimension to be sorted here. After the selection, the members of the dimension are displayed in the list. This can now be re-sorted using drag and drop.

Description

Enter a name for the configuration here.


Chart

Type

You can select the desired diagram type by clicking on the corresponding icon.

Orientation

All diagrams can be used horizontally and vertically aligned:

  • horizontal for developments over time (Time),
  • vertical for structural comparisons (Structure).

Base Chart

The Base Chart checkbox shows and hides the basic chart. This allows deviation charts to be used without basic charts.

Chart Type By Series

To display combination charts, select the desired chart type from the dropdown (None, Bar, Line, Offsetbar, Pin, Stackedbar, Waterfall).

Deviations

Configuration

Use the + sign to create deviations, which are shown above the basic diagram. To remove a deviation, click the red trash can. By default, an absolute and a percentage deviation are shown. The checkbox (de)activates the visibility of a deviation.

Configuration Pop-Up

The checkbox Enabled sets the visibility of the selected deviation.

  • Label: Name the deviation.
  • Type: Choose between absolute or percentage deviation.
  • Minuend: The value to be used as a reference value.
  • Subtrahend: The value that is checked to see how far it deviates from the reference value.

Calculation:

Absolute: minuend- subtrahend

Percentage: (minuend - subtrahend) / | subtrahend|

The order in which these deviation axes are displayed corresponds to the order in the Deviations Configuration.

Calculate Deviations from NULL

Specifies whether deviations should also be calculated from NULL values.

Good Color

Here you can set the color for positive connoted values by clicking on the corresponding colored circle to open the color picker.

Bad

Here you can set the colors for negatively connoted values by clicking on the corresponding colored circle to open the color picker.

Neutral Color

Here you can set the colors for neutral connoted values by clicking on the corresponding colored circle to open the color picker.

Negative Deviation Is Good

This option inverts the color scheme for the colors of the deviation. For example, negative values can be displayed with green color when using the original colors.

Deviation Bar Width for Scenarios

The Bar Width applies to the bar width (percent or absolute) of the absolute deviations. (Applies if the option 'Scenarios in Deviation' on the Data Tab is activated).

Deviation Pin Width

Use this option to define the width of the needle in the percentage deviation chart. The option takes effect when the 'Scenarios in Deviations' option is enabled on the Data Tab.

Pin Line Black

This option colors the needle line in the deviation graph black.

Use Pin Head Color

(De)activates the selected Pin Head Color. If deactivated, the stored color values of the deviations are applied (default: green/red)

Pin Head Color 

The head color of the needle in the percentage deviation diagram. The color is not applied to the needle heads in the base chart.

Pin Head Shape

Select which shape in the line chart is used for a data point. The following options are available:

  • circle
  • rect
  • rhomb
  • triangle
  • wedge
  • none


Layout

Padding

Padding in [px] sets a border around the diagram.

Spacing

Spacing also in [px] defines the distance between the basic and deviation diagram.

Space Proportion For Base Chart

Place that the Base Chart takes up. Formula for determining the space: Factor / (sum of all factors)

Space Proportion For Deviation Charts

Space that a deviation diagram takes up. Formula for determining the space:
Factor / (sum of all factors)

License

License Key 

Enter the license key here.