I am trying to use Templated Filters logic in LookML to filter a look/dashboard based on flexible dates i.e., whatever date range/value the user enters in the date filter. Below is my LookML,
view: orders {
derived_table: {
sql:
SELECT
customer_id,
price
FROM
Orders
WHERE Orders.Status = ‘Paid’
AND {% condition transaction_date_filter%} Orders.TransactionDate {% endcondition %}
;;
}
filter : transaction_date_filter {
type: date_time
}
}
The datatype of the TransactionDate field in the Orders table is DATETIME. But I get the below error,
No matching signature for operator >= for argument types: DATETIME, TIMESTAMP Signature: T1 >= T1 Unable to find common supertype for templated argument Input types for : {TIMESTAMP, DATETIME}
The SQL dialect used here is BigQuery. Can someone please help?