Filtering from Table

How to apply a Filter to your dataset

You can apply filters to your map to further analyze the data. Filters allow you to dig deep into your data. For example you can filter by customers in a specific area with a certain income.

There are three types of filter.

  • Numerical
  • Text
  • Date

Numerical Filters

By default the Table will be collapsed in the bottom right corner of the screen as seen below.

  • Click on the double arrows to expand it.
  • Select the dataset you wish to filter from the Viewing drop down.
  • Select the Sort/Filter button at the top of the column you wish to filter. This will open the Filter window beside the table.
  • Use the slider to change the value
  • Hover over the values to enter new values for the filter manually.
  • Click on the X icon to remove the filter.

Text Filters

If the Column is a text field and has less than 50 distinct values then the filter window will appear as below. This will allow you to choose one or more values.

  • Click on All to remove or add all results to the map.
  • Click on one or more choices to add or remove them from the map.
  • Click on the X icon to remove the filter.

 

If the Column is a text field and has more than 50 distinct values then the filter window will appear as below.

  • Click on the drop down and select the criteria you want and enter the appropriate value in the text box.
  • Click on the + to add another filter or click on the – to remove a filter.
  • Click on the X icon to remove the filter.

Date Filters

  • You can filter based on date values and date ranges. Make sure that the data has been imported as a date at the add data stage.
  • You can filter data directly from the legend by clicking on the eye icon beside each range.
  • You can filter from the table by clicking on the filter icon at the top right of the date column.
  • Use the ‘From’ and ‘To’ date to specify the start and end date of the data you want to view.