6 Replies Latest reply on Aug 9, 2013 12:03 PM by Alex Kerin

    Duplicating data source - data too large

    Alan Kwan

      Hi all,

       

      I have a dashboard on the server which measures individual performance against the team. Therefore, I needed to duplicate the first data source in order to compare the individual's score against the team's in the same sheet.

       

      The problem I am running into is, my data source is too big, it has a huge amount of  data which already takes awhile to refresh. By duplicating the data, it's basically running the big query twice, which is unnecessary. One bypass solution I can think of is to alter the duplicated data source query to query only the total summary. But I am just wondering, is there a way that the duplicated data source can use the same extract as the first one, so the query will only need to refresh once? Are any other suggestions?

       

      Thanks,

      Alan