Custom functions

The syntax for writing custom calculations in Marple Insight depends on the database it is connected to. For example, if the connected database is Marple DB, the correct syntax to use is PostgreSQL.

For convenience, you can search for signals on the right side and click on their names to insert them directly into your formula. When writing your custom formula, make sure to enclose signal names in brackets and quotes (e.g., ['SignalName']).

You will see a preview of the function signal displayed in red in the preview window.

On the right side, you can add more settings to your function:

• Name

• Description

• Unit

• Resample the time base of the input signal. This feature allows you to combine signals with different time bases into the same function.

• Flag with a star. By default, when opening the function library, a user will see his own functions and all starred functions. Add a star to functions that are relevant for all users in your workspace.

Any function that is available in the query language of your underlying database can be used. However, some Building blocks are added to make your life easier.

Click on the wanted building block, and fill in the signals/expressions.