Auto-filter 2nd Date based on 1st Date

calvintang — Thu, 22 Sep 2022 07:10:08 GMT

Here is my data model:

Table 1 (T1)

Table 2 (T2)

Location ID | Seller ID | T2.Date Sold | Customers

Table 3 (T3)

Location ID | Seller ID | T3.Prize Date | Customers

------------------------------------------------------------------------------------------------------------------------------------------------

The three tables are designed this way due to several limitations and legacy issues. We need to maintain this as we have 2 effective dates.

Problem is, we need to filter common dimensions: Location ID, Seller ID, Date Sold, Prize Date

In the dashboard, how do I create a filter for the Date Sold to match T1.Date Sold and T2.Date Sold, and separately for T1.Draw Date and T3.Draw Date?

Making all four the same name in the data load editor creates 7 sync keys -> Might be a big problem. I currently have 1 sync key thanks to Location ID and Seller ID, but I am okay with 1 sync key.

topic Auto-filter 2nd Date based on 1st Date in App Development

Auto-filter 2nd Date based on 1st Date