Custom formula column

Overview

A custom formula column allows users a new column where each cell's value is dynamically calculated based on a formula. The formula can reference other columns, perform calculations, apply logical operations, or even use built-in functions.

Example:

If you have a dataset with columns "Price" and "Quantity", you could create a custom formula column called "Total Cost" that multiplies these two columns, with a formula like:

= {Price} * {Quantity}

Open custom formula column pop-up

• For Table, you can create a Fx column by clicking on the icon next to the last column.

• For other widgets, you can find the Fx icon when adding the column to create a widget.

Create a custom formula column

• You will be asked to fill in the Column name and the Formula

• Select the arrows next to Fields and Functions to browse and pick the desired column easily.

• You can input directly into the Formula field to display results close to the result.

• Click the Save column button to finish the setup.

• Click the Discard button to go back to the previous state.

You can check at the bottom of the field to see if the Fx column is aggregated or analytic.

• The newly create Fx column will be on the right side of the Table.

• For other charts, you can select it on the list.

Edit a custom formula column

• Click on the 🖋️ icon of the Fx column.

• Click on the Formula text.

• You can click directly on Properties to edit it.

This column is local to the View and won’t impact the data model

• In pivot, aggregated/analytical columns can only be used in Values.

• In the vertical bar, the aggregated/analytical column can only be used for the Y-axis.

Delete a custom formula column

• Simply click the Delete button in the Edit column to delete the Fx column.