I have been struggling trying to create a dynamic filter based on a case statement in looker. I have a SQL query as follow:
CASE WHEN contract_end >= DATEADD(month,0, GETDATE()) THEN ‘Not Ended’
ELSE ‘Ended’ END AS “Contract Status”
I’m trying to create a filter that would allow me to dynamically look at last month or last year contracts that are “Not Ended”. This is easy to do in SQL but doesn’t seems to be an easy task in Looker.
Hopefully someone could help me with this,