Hello, if I put a filter on the date field I have this error
invalidQuery: No matching signature for operator >= for argument types: TIMESTAMP, DATE. Supported signature: ANY >= ANY at [34:11]
Solved! Go to Solution.
Change datatype to timestamp or datetime
Make sure that in the definition of your dimension_group you have added type:time
@Dawid if that's what i did
Change datatype to timestamp or datetime
@Dawid Thanks
if i have 2 views with each of the views has a date field is it possible on looker to filter from a single date filter from one view the measurements from the other view
In this case you could probably leverage the usage of Templated Filters. You can create a filter of type date_time and then feed its values as logical statements to the sql parameter of your timestamp dimensions. Here is a link that could help: