Filter
Last updated
Last updated
Filter is one of the most used actions on a table. On Acho Studio, you can apply as many filters as you would like and the logics for each one are recorded respectively.
On Acho Studio, you can Add a new filter, Copy current filter and Remove current filter.
Add a new filter: Generate an empty row consisting of Column, Logic, and Value.
Copy current filter: Generate a new filter that copies the column name and the logic of the current filter.
Remove current filter: Delete the current filter. However, if there is only one filter, you cannot remove it.
Filtering options are automatically configured based on the data type of the column in consideration:
is
contains / does not contain
is empty / is not empty
in / not in
starts with / does not start with
ends with / does not end with
is null / is not null
less than (<)
less than or equal to (<=)
equals (=)
not equal to (≠)
greater than or equal to (>=)
contains
is null/is not null
before (<)
is or before (<=)
is (=)
is or after (>=)
after (>)
contains
is null / is not null
is TRUE
is FALSE
contains
is null / is not null
Basic operators:
AND means both filters need to exist at the same time (e.g. Number > 10 AND Number < 100).
OR means only 1 filter needs to exist. (e.g. City is San Francisco OR City is New York). The logic toggles will show up when there are more than 2 filters. You can switch on/off the logic toggles.
Levels of logic toggles:
Universal level (AND/OR for all):
With the universal level toggle, you can switch all the toggles to OR or AND with a single click.
Individual level(AND/OR):
With the individual level one, you can only toggle the one you select. The universal one will affect all the individuals, while the individual will not affect the universal one.
In addition to the main filter action, a row of small filters is also available above the column names. The small filter is a quick way to find matching values within a particular column. The default logic for the small filter is "contains", so it will find all records containing the value inputted. It should also be noted that the small filters are NOT case-sensitive. When a value is inserted into the small filter, the result is updated right away. The small filters can be used to explore data more efficiently before setting up the main filters.
To better utilize the frequent filters you have, you can rely on the Favorite section on the right of the Filter Panel. You can do the following tasks here:
When you specify a set of filters, you can click Save as Favorite to save them for future use.
If you want to adjust one of your favorite filters, you can click the favorite filter to edit them. After updating it, you have two options to save the updated filters:
New Favorite: save it as a new set of favorite filters and keep the old ones as well.
Update: save them back to the existing favorite filters.
You can always rename or delete the favorite filters. Just hover on the favorite filter and click the "...", a dropdown will show up. Then you can select the option you need.
All the sets of favorite filters are account-based. This means you can apply your favorite filters in different projects. However, you cannot share your favorite filters with different accounts or other team members.
When you apply favorite filters to a project table, sometimes the system may not be able to find the column that you specify in filters. The following example is that the user wants to apply the covid_data_filter to the current table but the system cannot find the date column.
This situation may result from two reasons:
The target column has a different name in your current table.
The target column has a different data type, so the system cannot apply the filter.
When this problem shows up, you just need to specify the empty column and logic again or delete the filter.
