Defining Custom Filters

The KS6800A PathWave Measurement Analytics software enables applying custom filtering to view the chart with respect to a range of values from the same or different fields. Moreover, you have the option to apply the custom filters either to all plotted charts (global filtering) or to a specific chart. You may apply custom filters to charts with or without selection.

  1. After adding fields as charts, click Filters on the right pane.
  2. On the Create Filters pane, click Pick a field. Note that this option is available even if you select a range of values in one or more charts.

The Fields pane appears.
  1. To define values you wish to use for filtering data on the plotted charts, select one of the fields that has already been plotted or select another field in the Fields area. In the example below, keysight_row, which is not plotted, is selected.
  2. In the Actions area, click Create filter using Field.

The Custom Filter pane appears.

The areas shown in the Custom Filter pane are:

  1. Overview—displays information about the new filter being created along with the field name being used.
  2. Filter type—displays the type of filter, which enables the interface to define the values that shall be used for filtering. Note that the filter type is dependent on the data type (integer, float, string, boolean, timestamp) defined for the selected field. The various filter types defined in the KS6800A software are Range, Regular expression, Time range and Pick values.
  1. Filter—displays the interface for the selected Filter type to define the values for filtering.
  2. Description—displays the filtering expression based on the values set in Filter area. Not that the expression displayed here appears in the Global Filters area of the Measurement Explorer or on the selected chart.
  3. Actions—displays buttons to apply the defined filter either on all plotted charts or a specific chart. After you define a filter expression, the Create new global filter button is enabled by default. However, the Apply filter to selected chart button is enabled when you select a specific chart only. To see how these actions impact the plotted charts, see Applying Custom Filter to All Plotted Charts and Applying Custom Filter to Specific Chart, respectively.

Setting Filter type and Filter

Before we understand how to set filters for each filter type, let us see the correlation between various filter types and data types.

The following image, captured from another dataset, displays the possible data types included below the field name.

The following table indicates the filter types that appear in the Create Filters pane for each data type.

Data type Filter type
int32 Range
float64 Range
timestamp(ms) Time range
string Pick values, Regular expression
bool Pick values

The following section shows you the interface that appears for each Filter type:

Range (for int32 / float64 Data Type)

When you select any field that has values of the int32 or float64 type, the Filter type shall always appear as Range only. The following example shows the filter type for the Repair Time field, which consists data of float64 type.

  • In the Filter area, enter a number in either Minimum, Maximum, or both boxes. The number can be entered as decimal or whole, and can be positive or negative.
  • Minimum—the lower limit, to indicate that the filter contains all values from the selected field that are greater than the defined number.
  • Maximum—the upper limit, to indicate that the filter contains all values from the selected field that are less than or equal to the defined number.
As shown in the example above, the expression in Description shows that the filter shall include all values from the Repair Time field that are greater than -10 and less than or equal to 285.75.

Time Range (for timestamp Data Type)

When you select any field that has values of the timestamp(ms) type, the Filter type shall always appear as Time range only. The following example shows the filter type for the Date of Manufacture field, which consists data of timestamp(ms) type.

  • In the Filter area, enter a Date range in either Minimum Value, Maximum Value, or both fields. Enter a value either in MM/DD/YYYY format or choose the date, month and year from the calendar.
  • Minimum—the starting date, to indicate that the filter contains all dates from the selected field that fall after the defined timestamp.
  • Maximum—the ending date, to indicate that the filter contains all dates from the selected field that fall prior to or on the same date as the defined timestamp.
  • To choose the date, month and year from the calendar,
  1. Click the calendar icon to the right on either one or both fields, as shown in the image above.
  2. From the calendar that pops up, select the required date, month & year.

  • You may use the left and right navigation icons to change month.
  • The drop-down button helps you select another year.
  • When you click a date, the value is displayed on the respective field.

As shown in the example above, the expression in Description shows that the filter shall include all dates from the Date of Manufacture field that are greater than 31st July 2020 6:30 PM and less than or equal to 05 August 2020 6:30 PM.

Pick Values (for string / boolean Data Type)

When you select any field that has values of the string type, the Filter type has two options in the drop-down. By default, Pick values is selected. Similarly, for bool type, the Filter type shall always appear as Pick values only. The difference is that for the bool data type, only two values (true / false) are available.

The following example shows the filter type for the Error Code field, which consists data of string type.

  • In the Filter area, click the drop-down for Choose Values.
  • From the options that appear, which are the values from the selected field, select one or more values that must be applied as filters.

The number of values selected and the actual values selected are displayed in the Filter area.

As shown in the example above, the expression in Description shows that the filter shall include the selected values from the Error Code field.

Regular Expression (for string Data Type)

When you select any field that has values of the string type, the Filter type has two options in the drop-down. By default, Pick values is selected. Choose Regular expression to manually define one or more value or part of the value from the field for filter.

The following example shows the filter type for the Error Code field, which consists data of string type.

  • In the Filter area, enter a value or part of the value manually in the Regular Expression text box. In case you enter a part of the value, the KS6800A software uses those values from the field that contain the entered value.
As shown in the example above, the expression in Description shows that the filter value that has been set for the Error Code field.