Special functions
We developed functions to facilitate working with time series, fill in gaps or missing data points, allow conditional statements, cumulative sums and, shift the position of the elements inside.
Many synthetic expressions require two or more variables, in those cases, each of the values to be computed must have the same timestamp, otherwise the engine will not compute the expression. Fill missing() can help in these cases, as it fills the gaps where there is a missing value in any of the variables used within the expression. The syntax for this function is as follows:
fill_missing (expression, <first_fill>, <last_fill>, <fill_value>)
Parameters | Description | Value | Mandatory |
---|---|---|---|
Expression | The expression to be computed | N/A | YES |
first_fill | Determines how the gap should be filled. By default set to . | : Fills the gaps forward, starting in the most recent data point. : Fills in the gaps backward, starting in a oldest data point. None: No fill will be done. | NO |
last_fill | Determines how the gap should be filled, at the end of the time series. Comes in handy when you have to fill all gaps in the variables. By default the function is set to . | : Fills the gaps forward, starting in the most recent data point. |