Filtering multiple columns

[amgn]

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

Date2

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

[amgn]

Sorted, I can share if people are interested