Creating a calculated dimension

You can create a calculated dimension from the Master items tab in the assets panel. The expression editor opens from the Create new dimensions dialog.

Gehen Sie folgendermaßen vor:

1. Klicken Sie in der Symbolleiste auf Arbeitsblatt bearbeiten.

   Das Extras-Fenster wird auf der linken Seite angezeigt.

2. Click Master items in the assets panel.

3. Click the Dimensions heading on the Master items tab to expand the category.

4. Klicken Sie auf Neu erstellen.

   The Create new dimensions dialog opens.

5. Click in the Field text box to open the Add expression dialog.

You will now be able to add expressions in different ways, depending on you preferences and of different levels of complexity.

Using a common function

1. Select a field from the drop-down list.

2. Click the aggregation function you want to use.

3. Click Insert to insert the function and the field into the expression editor.

   TipphinweisYou can insert just a function or just a field by selecting only one of them.

4. Klicken Sie auf Übernehmen, um den Dialog Neue Formel zu schließen.

   Continue by adding the descriptive data for the dimension.

Adding an expression by typing

1. Type the expression directly in the expression editor.

   The field names you use in the expression are checked, and the syntax of the expression is validated.

   TipphinweisAs you type in the expression editor, the expression is validated continuously. If there is an error, you see a hint about what is incorrect. Additional error information may be available by clicking the icon next to the hint.

   Each line in the expression editor is numbered and syntax highlighting is used.

2. Klicken Sie auf Übernehmen, um den Dialog Neue Formel zu schließen.

   For a measure, you continue by adding the descriptive data for the measure.

Adding an expression through the properties panel

You can add an expression to a visualization through the properties panel.

1. Open the sheet with the visualization that you want to edit.

2. Click Edit sheet to open the properties panel. (If it is hidden, click Show properties in the lower right-hand corner to open it.)

3. Click the visualization that you want to edit.

   The properties panel for that visualization is displayed on the right-hand side.

4. Under Data, click Add data and select Dimension.

   A dimension text box is displayed.

5. Type your expression. The expression must begin with an equals sign (=), otherwise the string will be interpreted as text.

Detailed syntax help

You can open the online help with the full description of how to use the current function by double-clicking the function name in the expression editor and pressing Ctrl+H on the keyboard. This feature becomes available after having entered the first parenthesis of the expression after the function name.

Adding the descriptive data for the dimension

After having entered the expression, you need to add some descriptive information.

1. Geben Sie einen Namen für die Dimension ein.

2. Geben Sie eine Beschreibung für die Dimension ein (optional).

3. Optionally, click in the color drop down and select a color through one of the following methods:

   • Click one of the colors in the palette.
   • Type a 6 character color code in the Hex input field: #.
   • Click at the bottom of the dialog, select a color in the color wheel, and optionally adjust the saturation slider.

4. Tags hinzufügen (optional).

5. Klicken Sie auf Erstellen.

6. Click Close.

The calculated dimension is now saved in the Dimensions category of the Master items, and you can use it in visualizations.

• Arbeiten mit Formeln in Visualisierungen
• Dynamische Dimensionen