Searching and filtering events
To search and filter events, modify an SQL query in the search field, and then click the Run Query button. You can enter the SQL query manually or generate it by using the query builder.
Data aggregation and grouping is supported in SQL queries.
You can add filter conditions to an already generated SQL query in the window for viewing statistics, the events table, and the event details area.
To change the filtering settings in the Statistics window:
- Follow the steps to open the events table.
- Open Statistics details area by using one of the following methods:
- Click the
button in the top right corner of the events table, and then select Statistics.
- In the events table, click any value, and then select Statistics in the context menu that opens.
The Statistics details area appears in the right part of the web interface window.
- Click the
- Open the drop-down list of the relevant parameter and hover your mouse cursor over the necessary value.
- Change the filter settings by doing one of the following:
- To include only events with the selected value, click the
button.
- To exclude all events with the selected value, click the
button.
- To include only events with the selected value, click the
To change the filtering settings in the events table:
- Follow the steps to open the events table.
- Click an event parameter value in the events table.
- In the opened menu, select one of the following options:
- To show only events with the selected value, select Filter by this value.
- To exclude all events with the selected value from the table, select Exclude from filter.
To change the filter settings in the event details area:
- Follow the steps to open the events table.
- Click a relevant event to invoke the event details panel.
- Change the filter settings by doing one of the following:
- To include only events with the selected value, click the
button.
- To exclude all events with the selected value, click the
button.
- To include only events with the selected value, click the
As a result, the filter settings and the events table are updated, and the new search query is displayed in the upper part of the screen.
When you switch to the query builder, the parameters of a query entered manually in the search field are not transferred to the builder, so you will need to create your query again. The query created in the builder does not overwrite the query that was entered into the search string until you click the Apply button in the builder window.
Click the button to save the current filter.