2 Replies Latest reply on Mar 25, 2016 11:03 AM by Nicholas Hara

    Combine Two Datasets on Dates

    nick.cook.0

      I have two independent datasets. One contains goal broken out by year and month (and complete through end of year - Dec '16). The other dataset contains our measure against goal and is through today.

       

      I want to graph the two datasets together (performance against goal by Month) but when I do so the graph is limited to just historical data (i.e. data through today). Although, I want the Goal trend line to display for future months (i.e. through end of year).

       

      How do I get my goal dataset to display by Jan and Dec and the actual to plot up through today on the same chart?

        • 1. Re: Combine Two Datasets on Dates
          Derek Wong

          Which dataset are you using as your primary source? This might happen if you're using the historical dataset as primary, as it will create a "pseudo left join" relationship on those dates. If this is the case, just flip them around so that your data set with historical + future dates is the primary data source.

           

          If that doesn't work, it might be easier to diagnose the problem with a sample workbook.

          • 2. Re: Combine Two Datasets on Dates
            Nicholas Hara

            Hi Nick,

             

            I agree with Derek, it's much easier to understand the issue if we have a sample workbook to look at.

             

            My hunch, without looking at the workbook is that your primary data source has a subset of the date range of your secondary data source. If you rebuild the view with the secondary as the primary and the primary as the secondary (confused yet), then the issue should be resolved.

             

            Let us know!