How To Write Custom Filter Last 7 Days (since I need to do an OR statement)

[Jason_Sujaya]

Hi there I’m new to looker and I’ve been exploring the whole documentation but I’ve been stuck on a simple custom filter query. Does anyone know how to write the Custom filter to do the following logic?

(${tableA.date} on the last 7 days
OR ${tableB.date} on the last 7 days)

Thanks a lot.

[fabio1]

Hi Jason

Welcome to Looker. Try out this custom filter:

matches_filter(${a.date},`last 7 days`)
OR matches_filter(${b.date},`last 7 days`)