> For the complete documentation index, see [llms.txt](https://docs.marpledata.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.marpledata.com/docs/marple-insight/user-manuals/functions/built-in-functions.md).

# Built-in functions

For most database connection types, built-in functions are supported.

In the "Create signal" modal, select "Built-in" function type.\
Choose the signal you want to create a function for on the left, and fill in all required parameters.

<figure><img src="https://3590686807-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwEBNWlmdcxXBXd7oyqyR%2Fuploads%2FVNHRK6sGkckWMIMGiSyJ%2FwvnScreenShot%202026-08-20%20at%2012.47.27.png?alt=media&amp;token=9660cafb-7bf3-4f8c-9626-fdaff83230b1" alt=""><figcaption></figcaption></figure>

Following built-in functions are supported:

<table><thead><tr><th width="171">Function</th><th width="317">Description</th><th>Parameters</th></tr></thead><tbody><tr><td>Moving Aggregate</td><td>Moving aggregate of a signal</td><td>Aggregate - <em>The type of moving aggregate</em><br>Window Size - <em>The number of samples to average over</em></td></tr><tr><td>Cumulative Sum</td><td>Cumulative sum of a signal</td><td>Gain - <em>The gain of the signal</em></td></tr><tr><td>Integral</td><td>Integral of a signal using the midpoint rule</td><td>Gain - <em>The gain of the signal</em></td></tr><tr><td>Linear Calibration</td><td>Linear calibration of a signal</td><td>Gain - <em>The gain of the signal</em><br>Offset - <em>The offset of the signal</em></td></tr><tr><td>Clip</td><td>Backwards finite difference of a signal, i.e. v(t) - v(t-1)</td><td>Gain - <em>The gain of the signal</em></td></tr><tr><td>Derivative</td><td>Backwards discrete derivative of a signal, i.e. (v(t) - v(t-1)) / dt</td><td>Gain - <em>The gain of the signal</em></td></tr><tr><td>Remove outliers, stddev</td><td>Remove outliers of a signal using standard deviation</td><td>Std - <em>The standard deviation of the signal</em></td></tr><tr><td>Remove outliers, fixed limits</td><td>Remove outliers of a signal using fixed limits</td><td>Min<br>Max</td></tr><tr><td>Sample shift</td><td>Shift a signal by a number of samples</td><td>Shift - <em>The number of samples to shift the signal by</em></td></tr><tr><td>Zeroing</td><td>Offset the signal to be 0 at the first datapoint inside zoom range</td><td></td></tr><tr><td>Time</td><td>Select the time axis of a signal</td><td></td></tr></tbody></table>

## Discover Built-in Functions in 1 minute

{% embed url="<https://www.youtube.com/watch?index=23&list=PLtVuqpI9QpJAFtUEvuS23Z47XGHrRc_P9&v=pBbV8gWQ46w>" %}

Want to discover more Marple features in 1 minute? Check out other [1 Minute Marple videos](/docs/other-resources/1-minute-marple-videos.md)