Multiple filter criteria

[alteryxlim]

Hi,

I have the following set up for 3 filters (far right of the attached screenshot):

Filter 1: Filter for only the current month action items:

ToDate([Target Completion Date]) <= ToDate(DateTimeTrim(DateTimeToday(),"lastofmonth")) AND ToDate([Target Completion Date]) >= ToDate(DateTimeTrim(DateTimeToday(),"firstofmonth"))

Filter 2: Filter for only the previous month action items:

ToDate([Target Completion Date]) <= DateTimeAdd(DateTimeTrim(DateTimeToday(),"lastofmonth"), -1, 'month') AND ToDate([Target Completion Date]) >= DateTimeAdd(DateTimeTrim(DateTimeToday(),"firstofmonth"), -1, 'month')

Filter 3: Filter for both previous and current month action items:

ToDate([Target Completion Date]) <=DateTimeTrim(DateTimeToday(),"lastofmonth") AND ToDate([Target Completion Date]) >= DateTimeAdd(DateTimeTrim(DateTimeToday(),"firstofmonth"), -1, 'month')

Questions:

1. For the 3 filters above, I want to add another criterion. The criterion would be if one of the columns "Adequacy" reads "False". 

Can I just do AND([Adequacy]) ="False"

2. How do I go about to create a fourth filter where, in addition to the new criterion above, I want to also include action items for the current month and the previous months, i.e. as we are in March 2022, I want to show the results of March 2022 + all the months prior? Filter 3 only has March 2022 and Feb 2022.

[alteryxlim]

Just to be clear, any data that is of Boolean type, will result in a False value with the Alteryx command ![name of the column] So, in my case when I set the filter to:

[Project] = "Asset" AND ![Adequate]

the "![Adequate]" will filter for the FALSE values. Correct?

[binu_acs · Accepted solution]

@alteryxlim that is correct