ASK: Filter Boolean on Measure

[Muhammad_Ikhwan]

Hi,

I have issue with creating measure on a view. When put into explore, the query doesn’t run because the filter for the measure below is run as string, instead of boolean.
How can I tell LookML to run the filter for these measure as boolean?

Thanks

measure: mau {
type: count_distinct
filters: {
field: count_as_mau
value: “TRUE”
}
}

measure: gmv {
type: sum_distinct
sql_distinct_key: ${orderid} ;;
filters: {
field: count_as_gmv_and_trx
value: “TRUE”
}
}

[Dawid]

Hi Muhammad,

If the dimension in question is defined as yes/nodimension you’d have to use

filters: {
    field: count_as_mau
    value: "Yes"
}

[Muhammad_Ikhwan]

Thanks Dawid.
That solve the issue for me