KatherineOakey
4 years agoQrew Member
Tips and/or tricks to get complex filters in the correct order and grouping
I have a number of fields I want to filter on in a report.
I know how to use and/or and parenthesis to group and filter as I want.
I have fiddled with the filters in this report repeatedly and it seems the biggest challenge is that as I add conditions, figuring out how to get the all/any (and/or) grouping correctly is such a challenge.
Seems like when I add in a new condition, I can't figure out how to get that condition evaluated as I want to sometimes without having to re-add other fields.
Are there any good tips or hints on how to get a complete set of filters/conditions set up in a report?
------------------------------
Katherine Oakey
------------------------------
I know how to use and/or and parenthesis to group and filter as I want.
I have fiddled with the filters in this report repeatedly and it seems the biggest challenge is that as I add conditions, figuring out how to get the all/any (and/or) grouping correctly is such a challenge.
Seems like when I add in a new condition, I can't figure out how to get that condition evaluated as I want to sometimes without having to re-add other fields.
Are there any good tips or hints on how to get a complete set of filters/conditions set up in a report?
------------------------------
Katherine Oakey
------------------------------