2 Replies Latest reply on Oct 8, 2016 7:57 PM by Sherzodbek Ibragimov

    Query Optimization on Dual Axis

    Sherzodbek Ibragimov

      I have problem with loading and querying time as it is taking too much time to load sheet as well as when each filter options are clicked first time. I have 13 filters and data for 10 year period. i have attached a mock up workbook to represent the structure of my data. Especially, once I established dual axis where filter only applies to one graph and other stays unchanged, it got even worse. My question is how I can improve load and query time without duplicating my master data to achieve my goal? All possible options with instructions greatly appreciated. Thank you so much. 

       

      PS: Ryan Sleeper advised me to utilize LOD expression, but I am not sure how I can apply to my case.