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>)