Basic filter help

Question

New to Alteryx and trying to start off by learning the most streamlined way of a formula in a filter

I have a current quarter field and a prior quarter field which both include a flagging.  Let's call them A, B, C, D & E.

I want the 'T' of the filter to show any row of data that is not D or E this quarter AND not D & E the prior quarter.

I can see the long winded approach but I'm just trying to learn multiple ways here.  Any help appreciated.

Thanks

Ben

alexnajm · Answer

If I understand correctly, this should work: [This Quarter] NOT IN ('D','E') AND [Prior Quarter] NOT IN ('D','E')

ed_hayter · Answer

[Current Quarter] != "D" OR [Current Quarter] != "E" AND [Prior Quarter] != "D" OR [Prior Quarter] != "E"

Should do the trick != meaning does not equal so that the True anchor is what you want. For the tests between OR remember to put the field being referred to again. I.E. DO NOT put [Current Quarter]  != "D" OR "E" but DO PUT [Current Quarter] != "D" OR [Current Quarter] != "E"

caltang · Answer

If your data has both current quarter and previous quarter in the same column, then the formula:

Flagging != D

AND

Flagging != E

You can use the custom filter in your filter tool to achieve this.