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

    Adding date selector parameter to Custom sql

    Sowmya Potluri



      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!