how do I input multiple values in the filter. Say I have 10 items and I want to filter on rows where the a data element equals one of a the 10 values. How do I do this?
To filter rows where a data element equals one of several specified values, you can use the "Contains Any Of" operator. Here's how:
1. Click the filters button at the top of your table.
2. Click "+ Add filter".
3. Select the column you want to filter.
4. Choose the "Contains Any Of" operator.
5. Enter your multiple values, separated by commas.
This will filter your data to show rows where the selected column contains any of the specified values.
If you need more complex filtering, consider using filter groups, which allow you to combine multiple filters using AND or OR logic.