Dynamic filtering inside custom timeframe

[AndrewMBaines]

Ideally, you'd create a date dimension to handle that.

If you can't extend the database, what database are you using and what have you tried so far?

Does this help:

Trying to calculate last 30 days from a date using variable in SQL

Got it! The problem is Postgres being awkward. It never does an implicit cast. Try: {{period}}::INTERVAL That forces the varchar to be cast to an interval.