Filter
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.
Filter actions
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.
Filter logics
Filtering options are automatically configured based on the data type of the column in consideration:
String
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
Integer/Float
less than (<)
less than or equal to (<=)
equals (=)
not equal to (≠)
greater than or equal to (>=)
contains
is null/is not null
Date/Datetime/Time/Timestamp
before (<)
is or before (<=)
is (=)
is or after (>=)
after (>)
contains
is null / is not null
Boolean
is TRUE
is FALSE
contains
is null / is not null
Filter Operators
Basic operators:
ANDmeans both filters need to exist at the same time (e.g. Number > 10 AND Number < 100).ORmeans 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
ORorANDwith 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.
Small filter
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.
Favorite filter
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:
Create new favorite filters
When you specify a set of filters, you can click Save as Favorite to save them for future use.
Update favorite filters
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.
Rename & delete 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.
Troubleshooting
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_filterto 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.
Last updated
