Adhoc view filter to allow looking back exact prior months from current date
Currently, by using DAY or MONTH, etc it won't give you the exact day you're looking for. Example: If you run this in Postgres to demonstrate the option you're saying by using DAY - 180 select current_date - INTERVAL '6 months', current_date - INT...