Skip to main content
Skip table of contents

Coding variables using Logical Expression Builder (LEB)

What is a logical expression?

A logical expression is the combination of different variables using logical operators. In DataTile you can use variations of the following logical operators to create logical expressions:

  • OR,

  • AND,

  • NOT,

  • ANY ... OF.

In DataTile, there are two key ways that you can build coding within crosstab:

  1. Coding within the table: you can build basic logical expressions through combining options within crosstab, click here to learn more.

  2. Coding in the Logical Expression Builder (LEB): to create more advanced codes in crosstab, filters or split you should use the Logical Expression Builder.

You can identify the logical expression builder anywhere in DataTile by the 'logical expression' icons (gray or red):

LEB-icon.png

LEB in crosstab

To open the expression builder window hover over a row/column and click the icon next to a variable name.

leb in crosstab.png

In the opened window you can build a new expression:

  • Drag&drop a variable you want to use to the window and choose the correct logical operator;

  • You can easily change the operator afterwards by clicking on it;

  • The logical operator 'NOT' can be activated by clicking on the blue dot to the left of the variable.

LEB in action.gif

LEB in split

To open the Logical expression builder for split, click anywhere in the split ‘zone’ except directly on a variable. Then, find the LEB icon on the right of each split option within the submenu.

LEB in splits.png

After the logical expression is complete, click 'Calculate' and get new calculations in a crosstab.

LEB in filters

To open the Logical expression builder for filters, click anywhere in the filter drop zone. This is the same for both crosstab and control editors in dashboards.

LEB in controls.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.