Hello,
I have an issue that I am trying to solve. I have looked at multiple thread on the forum, but I have not been able to solve my issue.
I will try to describe what I am trying to achieve and hopefully I will be able to receive some advice from the community
I have a table as follow (In a view):
Date1 and date2 can be described as follow:
- Date1 is a clustered key in a table (>40 millions rows)
- Date2 is a function of date 1 (calculated in Looker). Not available in the table.
- The function between the 2 dates can be described as :
Date2=date_add(day, n, Date1) with n in the range [-7,7]
What I would like to achieve?:
- When a filter is applied on Date2 (on dashboard), automatically filter on date1 that would following these rules:
- With date2 in between filter_date2_min & filter_date2_max
- Filter as date1 in between filter_date2_min-7 & Filter_date2_max+7
- The user need to be able to use Absolute and relative date
What is the key benefit?
- While the user apply a filter on date2 (calculated dimension) a filter is applied on date1 (clustered key). I hope this will increase the speed of the dasboard