I have used Custom SQL with UNION all to only required Column's from 3 tables. with few conditions in Custom SQL & DATE PARAMETER.
Now i have to create Extract with Refresh schedule.
- Everyday data is appended
- Customer can choose any date in last 2 years(now we have only 8 months data)
- I'm stuck in creating extract or refreshing extract (In server it shows only for one date data, as Parameter is not auto update)
Need your help.
For your information, parameters are static in tableau. You should create date parameter using your date field (datasource). So once you refresh the data your parameter will get update post refresh.