Filter by comparing columns

If you only want to return rows where one column has a certain relationship (e.g., greater than, less than, etc.) to another column, you can use the “Filter” step to compare these columns.

In the example below, we have a table chart with the monthly number of issues within the status of “To Do”, “In Progress”, or “Done”. We want to return only rows where our monthly number of issues in the Done status is higher than our monthly number of issues in the In Progress status. Here’s the chart we’re working with:

Add a “Filter” step and use the following settings:

If you’d like to set multiple rules, you can do add more by clicking +Add condition. When you’re done adding filter rules, click Save.

Your chart results are now automatically filtered depending on the selected columns’ results.