2 Replies Latest reply: Oct 29, 2013 12:23 PM by Jihan Wang RSS

    QV Running Slow

    Jihan Wang

      Hi QV folks,

       

      I developed a simple dashboard. The data structure is simple, an inpatient table and an emergency department table linked through a link table by account.

       

      I created several charts for both inpatients and emergency department tabs/sheets; however, my emergency department sheet runs extremely slow. One of the issue that I found through google is that I used count(distinct) function because the emergency table has duplicate account to account for cycle time of each individual process step. I modified my data table to be able to use sum(). But QV still runs slowly.

       

      I have developed 2 dashboards using QV before and have never seen such a issue. Does anyone have similar experience and would like to share your resolutions? Andif you have any references materials to optimize QV performance?

       

      Thank you so much!

       

      Regards,

      Jihan