4 Replies Latest reply on Nov 15, 2017 1:26 AM by P S

    Speed up dashboard

    P S

      Hi

      I have a dashboard where I have 4 graphs (4 seperate worksheets) and the data source is a static table (materialised view) with some 3 million rows.

      I have a query inTableau similar to "select * from my_materialise_view where date <= <<parameter_date_in_tableau>>"

      I then have 3 quick filters used in the dashboard and I also have many LOD calculations using and if statement within each LOD.

      Each time I change a filter or the date parameter then it takes around 40 seconds to run. Looking for suggestions to speed this up.

      Would it be much quicker if the IF logic used in the LOD's were carried out in the initial sql (materialized view).

      Also, the main filter has 4 categories to chose from - would it be quicker if I had 4 seperate worksheets for each category then use the remaining 2 filters from within each of these separate category sheets.

      Just looking for some ideas.

      Thanks

        • 1. Re: Speed up dashboard
          Neil Lord

          Hi,

           

          How many columns do you have in your view? If you don't need them all, remove them from you SELECT statement.

           

          Do you need the data at the level of granularity that you are currently using? If no then create an aggregated view.

           

          If you've done these things and it's still slow, then it's definitely worth trying to push you LOD calcs on to the DB rather than Tableau doing them.

          1 of 1 people found this helpful
          • 2. Re: Speed up dashboard
            Alvino Vaz

            Hi,

             

            You can use performance recording and analyze your workbooks performance.

            Use the following to Record and Analyze Workbook Performance

             

            Record and Analyze Workbook Performance

            Regards,

            Alvino Vaz

            1 of 1 people found this helpful
            • 3. Re: Speed up dashboard
              Michael Hesser

              ...this might sound like a silly suggestion, but if you're using multiple values filters, make sure you Customize them to include the Apply button. This prevents Tableau from making calculations until the user has confirmed all his/her choices.

               

               

              Good luck! --Michael

              1 of 1 people found this helpful
              • 4. Re: Speed up dashboard
                P S

                Thanks everybody.

                I move the LOD calcs (where i could) to the sql. Used the Apply to the filters and this has helped reduce the time to open the viz.

                Many thanks