1 Reply Latest reply on Jun 25, 2018 1:35 PM by Patrick A Van Der Hyde

    Adding date selector parameter to Custom sql

    Sowmya Potluri

      Hello,

       

      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!

       

      Thanks,sowmya