Hi! I was trying to do some questions with metabase, but struggle to figure out how to properly add query for calculated field. I need to select entities, that differ from date range for 2 weeks (
interval '2 week' in PG), but I cant add any calulations to query. I tried two different ways:
- Add custom field, but it does not support intervals in definitions, so something like this does not work
= [Users.created_at] + interval '2 week'
- Second approach was creating SQL question, but problem is recommended way is to select field in the variable definition like and I cant add interval into this condition, but general recommendation is to keep conditions column names in the variable.
Is there are any way to solve this problem? Or only way is to add 2 variables and prohibiting rule of keeping field name inside variable definition?