Looker explore issues in custom filter

[mohapatrad-1661]

Hi All,

In custom filter, I want to give the measure to take YTD data along with some specific id.My YTD condition is working fine.When I give AND condition to put all those ids using IN condition, error is shown as Expression incomplete. My code snippet is as below.

extract_months(${booking_date}) <= extract_months(now())
AND
extract_days(${booking_date}) <= extract_days(now())
AND
extract_years(${booking_date}) = extract_years(now())

AND

(${id}) IN ("AB123”) -----after adding this line error comes

[santosh_Kolekar]

We are using three different data sources in blend Data sources(Cloud SQL for MySQ, Google Sheets and BigQuery).
I am getting some values in dropdown and table as Null or Blank.

Expected: Show some meaningful value for null like NA or Not available.

Can you someone please help on this.