How to pass liquid parameters to `date` fields filters?

How to pass liquid parameters to `date` fields filters?

I can pass parameter to string filters  like this 

  filters: [ date: "1 day ago"  ] 

but

  filter: dt_filter {
type: date
}

measure: sum_filt_by_dt {
type: sum
filters: [ date: "{% date_end dt_filter %}"] #< --- Error here
sql: ${age} ;;
}

throws 
 

0e5f7a00-1058-4427-9de7-8aa8b8637df1.png

Why it is possible  for string fields but not for dates?
This works fine for unquoted parameters:

  dimension: gender {
type: string
sql: ${TABLE}.gender ;;
}

...
filters: [ gender: "{% parameter gender_param %}"]
0 1 573
1 REPLY 1

otto
New Member

You can add a yesno dimension that uses your dt_filter and then use that in the measure filters

dimension: dt_yesno {
type: yesno
sql: {% condition dt_filter %} your_date_field {% endcondition %} ;;
}

measure: sum_filt_by_dt {
type: sum
filters: [ dt_yesno: "yes" ]
sql: ${age} ;;
}

I think why it works for you for the string fields is that you’re using a parameter there, which is a different thing than filter.

Top Labels in this Space
Top Solution Authors