When a filter combines AND and OR conditions with parentheses, Apsona restructures it to align with Salesforce SOQL’s strict grouping rules.
Reason: SOQL does not interpret parentheses exactly as shown in the Apsona UI.
Behavior: To preserve intended results, Apsona duplicates shared conditions across each OR branch.
Impact: The filter may look longer and more complex but performance and accuracy are unaffected.
Best Practice: To reduce duplication, use pre-filtered reports or segments for common conditions, and keep a separate note of your original grouping for clarity.