This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Wondered if i could grab some help please. It's probably something so simple but cant seem to pinpoint where i am going wrong.
I seem to be struggling with "and" and "or" expressions within a filter.
What I'm trying to filter is;
If 'SO TYPE' = AT Once and the 'ORDER STATUS' = Booked - only ( some results have partially available balance booked - i just want 'booked' by itself) but also if 'SO TYPE' is Cust At-OnceCall-Off and 'ORDER STATUS' = Contract managed
So it will search for the first criteria 1st then the 2nd criteria but both criteria filter the output through True
This is what I've got so far below:
[SO Type Desc]="At-Once Order" AND [SO Type Desc]="Cust At-OnceCall-off" and [Order Status]="Booked" and [Order Status]="Contract Managed"
I've tried various versions of this with AND and OR or CONTAINS but either doesnt filter anything or not all the information.
After years of using Alteryx I still can't my head round the AND OR functionality but I always try and think of it as...If the values are in the same column use AND if they are in different columns use OR
So i would try:
([SO Type Desc]="At-Once Order" AND [SO Type Desc]="Cust At-OnceCall-off") OR ([Order Status]="Booked" and [Order Status]="Contract Managed")
Without some data it's hard to know the exact results of that but I'd try this first
I'm hoping to make it that anything that is 'At Once' and = 'Booked' also 'Cust At-OnceCall-off' and = "contract managed" are filtered off as these arent needed but it never filters the data and just includes all the data from before the filter.