Using Table Filters


You can use Filters to search for specific values in tables, or to display specific types of values.

To activate the filter, click on the Add Filters link:

https://helpcenter-io.s3.amazonaws.com/uploads/erm/OKnl5TnTdJi9PTgy2EVKlqMLnVzx6NTxjWg4IxX3.pngpng

The filter dialog will be displayed:

https://helpcenter-io.s3.amazonaws.com/uploads/erm/0TG4d8mW5MjPs8MnMVC5Dv6OpVBOTnOHuCHnSKUP.pngpng

Attribute

Use the Attribute and Condition boxes to select the Field to filter on as well as the type of condition (equals, not equals, between...)

First, click on the Attribute box, a tabbed list of the fields available for that table will be displayed. Simply click on the field name to select it:

https://helpcenter-io.s3.amazonaws.com/uploads/erm/9GiJ0s3Pf6zbGs0t2z9fQXDUUUjcQPqenWBIU8dA.pngpng

Condition

Set the condition to use to limit the results, click on the Condition box and select the appropriate option:

https://helpcenter-io.s3.amazonaws.com/uploads/erm/hjBgk3qIoK7m7vxoZg4Dlt90XzNVe8VhGOhuoMFZ.pngpng

Then set the filter value in the box (or boxes) provided:

https://helpcenter-io.s3.amazonaws.com/uploads/erm/3tv6FEGMXc8SJhPYFBTmXRVdpyb2D0Y4uzDXroLA.pngpng
https://helpcenter-io.s3.amazonaws.com/uploads/erm/fjIbX1MuI4jCmmPLYDh4cnZ8UBqbYtM1Htq32Q7z.pngpng

Click the Apply Filter button to activate. Click the X button to clear an existing filter.


Example

For example, if we want to filter a table on Funding Year:

  1. Click the Add Filters button

  2. In the Select Attributes drop-down, locate the "Year" option

    https://helpcenter-io.s3.amazonaws.com/uploads/erm/A18ZNgEXV1gMRQTdrc44DEKlKh4dYFoL7WbcRcdh.pngpng
  3. In the Condition drop-down select "equal to"

    https://helpcenter-io.s3.amazonaws.com/uploads/erm/fzFzQn4sGfQLDb8Zs21XHUDIsRUFMCjtVJu6WZ2U.pngpng
  4. In the Value box, type the desired Year

    https://helpcenter-io.s3.amazonaws.com/uploads/erm/6NjRDGK9d5BKqPbTjON2exLecTXkif4DvMQemPD6.pngpng
  5. Click Apply Filter


Was this article helpful?