2 Replies Latest reply on Feb 26, 2018 3:58 AM by Sivasankar Muthusamy

    Filter on worksheets - Multiple full scan of tables

    Sivasankar Muthusamy

      Hi

       

      I have built a data source to retrieve the data for 30 days and then made them to show it in different worksheet, each will show the data for 24 hours, 48 hours and last 7 days and last 30 days. Filters applied on the data source level to filter the 30 days of data and then each worksheet will have the filter to applied to show the required time range. When I look at the database query log, it shows around 6 queries running and full table scans were performed. I assume each worksheet sends a separate query  to the database and then brings the data back to tableau. My expectation was that it should have run only one SQL query for 30 days  of data and then perform all worksheet associated filters within tableau.