Filter column data using the OR selector
You can also filter the data using the OR selector, allowing you to include specific values from one or several columns to define a filter that displays events that meet x OR y conditions.
- Select the icon in the query window toolbar and the Operations Over Columns window appears with the OR option selected.
- Hover over a column header and a down-arrow icon appears. Select it to open the top 10 column menu. Select the check box of any value from this list. Now select at least one more value from the list to add it to the OR filter. You can also select column values from other columns.
- Select the operators that define the filter you wish to create and select Apply. In this example, we wanted to look at the session events that had a status code of either OK (200) or Bad request (400). We also cloned the 400 status code and applied a different operation to the cloned version.
You can also apply an OR filter directly in the top 10 values list. The Operations Over Columns window will appear once you select the first value.