2 Replies Latest reply on Oct 30, 2017 12:56 PM by venkatram

    Date Filters from each Custom SQL Query Data source

    Vista Sword



      I am using 2 Custom SQL Queries.


      Custom SQL Query 1 = 1 calculated field(Average)

      Custom SQL Query 2 = 2 and more calculated field(Quartiles)


      I use the date filters (Month, Year, Quarter) from Custom SQL Query 2, the problem is I cant filter the Average because it came from Custom SQL Query 1. Was there any workaround to filter the Average by month, year and quarter?


      I already used the data blending but it is causing some data discrepancy and misalignment of the dashboard. If you were wondering why I am using the 2 custom sql queries, it is because of our client's dashboard behavior/purpose requirements.