I would like to know if there is a way to set up a filter where there are 3 layers of condition filters. At the moment I can only seem to manage to have a two layer filter. I am not sure how to explain it so I hope everyone understands what I mean.
Josh Ambrose shared this idea · Jul 3, 2017
When I have complicated conditions that the Filters cannot handle, I will create a calculated field on the table and write on the conditions in a large If/Then statement.
A 1 or 0 works well to represent Yes/No, and also allows me to dual purpose the results in charts if I want to sum the values.
Once the calculated field is in place, use that in your Filter.
One filter criteris: Where calc-field = 1, etc.
I do the same as John. Filters can turn into a giant mess of and/ors pretty quickly. Its much easier to code some if statements and filter based on those results.
Thank you for reaching out with your question.
Matt & John's suggestions are definitely great options for when setting up a filter, however, more simply (if you didn't realize the function is there in the filter builder) is the ability to add as many "Conditional Groups" as you want or need to the filter you are building.
If you scroll down to the very end of your list of fields on your table (that display on the left-hand side of the screen when you are in the filter builder) you will see a green button that says "+ ADD CONDITIONAL GROUP".
This feature can be used to separate out different layers and conditions of your filter you are building with either the "And" or "Or" option for the condition group.
If it turns out that you have more questions on this, please do not hesitate to email us at firstname.lastname@example.org.
Thank you all for getting back to me, I probably well just jump on the coding as I used to do a lot of coding back in the day.
@Justin - I knew about the "and" "or" add conditional group but I can still only get it to do Or -> And (2 layers) for the filter I want / need I need an Or -> And -> Or filter (3 layers) as at the moment I'd have to do about 14 different complex Or -> And filters and it justs get messy and too much work to maintain. Thank you anyway though.
Please sign in to leave a comment.