Here is my data model:
Table 1 (T1)
Location ID | Seller ID | T1.Date Sold | T1.Prize Date | Sold Amount | Sold Tickets
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.