FillGaps

Fill of data gaps in the data set.

The function interpolates the missing values of time dependent data and returns linearly interpolated values. Gapfilling algorithm does not touch the raw data in the database. In case of using the gap filling function on any data keep in mind that the raw data stays the same with no gaps filled.

Syntax

 FillGaps(expression)

expression: signal expression

Example

FillGaps("produced water per time increment" in "STB")

As you see in the following table the GapFilling function applied on the 'original signal' as input:

 

Date/Time

 

Original Signal1

 

FillGaps(Signal1)

 

01.02.2007 00:00

333.5553554

333.5553554

01.03.2007 00:00

352.951806

352.951806

01.04.2007 00:00

220.992347

220.992347

01.05.2007 00:00

#NULL!

177.4695736

01.06.2007 00:00

#NULL!

133.9468003

01.07.2007 00:00

#NULL!

90.42402688

01.08.2007 00:00

46.9012535

46.9012535

01.09.2007 00:00

375.8459772

375.8459772

Fill gaps by using a linear interpolation or by carrying forward the last value found in the current time range.

Syntax

FillGaps(numeric, string interpolation Type)

Examples

FillGaps ("oil production rate" in "m3/h", "Linear")

FillGaps("oil production rate" in "m3/h", "Last")

 

Fill gaps by carrying forward the last value found in the scope time range with reset condition.

Syntax

FillGaps(numeric, boolean conditionExpression)

Examples

FillGaps("oil production rate" in "m3/h", "gas production rate" in "m3/h" >0)

 

 

Fill gaps by using a linear interpolation or by carrying forward the last value found in the time range started with specified start date.

Syntax

FillGaps(numeric, string interpolationType, date/time startDate)

Examples

FillGaps ("oil production rate" in "m3/h", "Linear", #02/24/2015 08:00#)

FillGaps("oil production rate" in "m3/h", "Last", StartOf())