Hi,
I have two tables T1 left join T2
when I create a date range filter, I get all the dates of T2, I want only the date range of T1.
eg:T1 has all the dates from jan 2020 till March 2021 and T2 has dates from 1985 till 2022
so when I create date range filter : I see from 1985----2022(I don't want this)
I want date range filter from jan 2020-March 2021
Pls assist.
8 answers
Pull date field from T1 to filter section or another approach use blending with T1 as primary and T2 as secondary and use filter from T1 table