Filtering
Filter data shown in each chart by setting a series of column filters on the Data tab.
A quick filter option is also available.
Quick Filter
Need to quickly filter the data that appears in the chart? Click the magnifying glass in the main toolbar, and type in a word or number that appears in all rows you want to appear in the chart.
Column Filters
Click on the Data tab. On every column header of the data table, there is an icon with 3 horizontal lines. Click it to set filters on an individual column.
Multiple filters can be set on each column. The filter types are explained below.
Text Filter
Filters on text columns include:
- Contains and Not Contains
- Equals and Not Equals
- Starts With and Ends with
- Blank and Not Blank
Number Filter
Filters on numerical columns include:
- Equals and Not Equals
- Less than and Less than or equals
- Greater than and Greater than or equals
- In range
- Blank and Not Blank
Date Filter
Filters on date columns include:
- Equals and Not Equals
- Less than
- Greater than
- In range
- Blank and Not Blank