error date filter

[tatuspark]

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]

[Dawid]

Make sure that in the definition of your dimension_group you have added type:time

[tatuspark]

@Dawid   if that's what i did

[Dawid · Accepted solution]

Change datatype to timestamp or datetime

[tatuspark]

@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

[Dawid]

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:

https://help.looker.com/hc/en-us/articles/360001285847-Timeframe-vs-Timeframe-Analysis-Using-Templat...