Use filters to determine which data to include in the results. Use Simple filters to quickly select one or more columns or metrics to use as a filter. Use the Advanced filters to create a more complex, text-based filter.
In the Interactive Query Builder, users can select which events are passed to the aggregation function. If an event doesn't match the filter, the aggregation function doesn't see it. Columns used in the filter also need to be scanned or evaluated.