Hi Marta,
Unfortunately, the dashboard filters have not supported multiple value inputs for “Contains” operator yet. We might add it in the near future, so the filters would be more flexible for you.
That said, here are some workarounds for your case, depending on how your data is stored.
Case 1: If many products share the exact same recipe from the list_of_ingredients.
→ In this case, I would suggest you try the “IS” syntax for the ‘list_of_ingredients’
filter, and select the values you want from the drop-down. This drop-down list should show all distinct values of 'list_of_ingredients'
.
This should take much less effort for you in this situation.
Let me give you an example with my “Countries & cities” dashboard’s filter:
Case 2: If each product has its own unique recipe from the list_of_ingredients.
→ Since the filter conditions on a dashboard are currently linked with each other by the AND operators, you can: add a filter where ‘field_1’ contains ‘string_a’, and then another filter with ‘field_1’ contains ‘string_b’ (and so on). This should get you the result where ‘field_1’
contains both ‘string_a’
and ‘string_b’
inside it.
Example for it here:
Please let me know if this helps!