i am trying to add date selector ( Current date, select your date and date range ) to the table in custom sql... and its getting failed... can some one tell me how to write a sql for these scenarios
The table should be connected live to use (prompt user ) for end clients...
The table data is huge and the performance getting slow... and on server its showing error due to time exception limit..
i tried to reduce the size of data on datasource level by adding date as filter and pulled last 2 months... but still its taking same time to pull data ... when users trying to select date from date selector... each time its taking 15 min to retrieve data... i am not sure how should i improve the performance of dashboard..
Appreciate your help!
The specific custom sql to write will be somewhat dependent on your data source. There is a good article on this topic here: https://www.theinformationlab.co.uk/2016/02/09/using-custom-sql-fill-date-range-tableau/
Regards and keep vizing.