Cookie Notice

This website uses cookies to ensure you get the best experience on our website. By using this site you agree to the use of cookies. We also use Google Analytics for statistical purposes. By selecting "Accept" you agree to the use of cookies by the Google web analysis service. Learn more about our Data Protection Policies.
Filtering by Values

Filtering by Values

Navigation:

Filtering by Values

The Filter values method is performed in two steps. In the first step, the values of a time series are filtered according to their relationship to a value (filter condition). In the second step, the values that fulfill the filter condition are assigned a replacement value.

There are three possibilities for the replacement value:

  • Replace with given value: The values that fulfill the filter condition are replaced with a freely definable value (optionally with unit).
  • Insert empty data point: The values that meet the filter condition are replaced by empty data values (NaNs). The time points remain as empty data points so that an originally equally spaced time series is still equally spaced after filtering.
  • Erase data point: The values that fulfill the filter condition and the corresponding times are deleted from the time series. This usually results in an unequally spaced time series from an equally spaced time series.

Start Method

To start the method, select Methods → Filter → Filter values from the ribbon (see following figure) or the context menu of the time series in the Project Explorer or use the key combination <Ctrl>+>Alt>+<U>.

In the window that opens (see following figure), select the time series to be processed under Time series. A multiple selection is not possible.

Filter Condition

Under Filter values matching condition you define the ratio of the values to be filtered out to a Number within a Tolerance range. The Number, the corresponding Unit, and the Tolerance can be freely determined. The comparison operators >=, =, and <= are available for the ratio to the value. The following applies in detail:

  • Greater than or equal to: Every value in the time series that is greater than or equal to the entered Number receives the replacement value.
  • Equal: Every value of the time series that is equal to the entered Number receives the replacement value.
  • Less than or equal to: Every value in the time series that is less than or equal to the entered Number receives the replacement value.

If necessary, the Tolerance limit for the filter condition can be adjusted.

The Filter empty data points option disables the selection by values. Only empty data points are assigned the replacement value.

The following figure schematically illustrates the process of filtering by values (here: clean up).

Further Settings

The replacement value is determined under Parameter for replacement (see above).

Finally, you select whether the respective existing time series should be overwritten with the filtered values or whether a new time series should be created in addition.

Transferring the filter results to a parallel time series

To be able to transfer the filter result to parallel time series with the same points in time, the replacement values 0 and 1 are used during filtering. Then the time series of the filter results (first time series) is multiplied by the time series to which the filter points are to be transferred (second time series). In this way, the second time series is filtered according to the points in time at which a specific value or value range occurs in the first time series. This is useful, for example, for filtering peak-load time windows.

Back To Top