I want to add a 12 months look back filter to the explore so that, the explore always gets the data for the last 12months. currently I have a dimension created with type date_month_name in the view for a given date column from the database table
If you only ever want your explore to show the most recent twelve months, use a sql_always_where with the appropriate database syntax. Without knowing what you’re using, it’s going to be something like:
date > (now() - 12 months)
Your database likely contains functionality to perform date math like that.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.