4 Replies Latest reply: Jul 13, 2018 4:45 AM by Del Booth RSS

    Two master calendar date son a single chart

    Del Booth

      Hi .

       

      Is it possible to plot two set of data that each has their own master calendar on one line graph, the data is from two tables (databases) that do not have a unique identifier between them.

       

      for example

      Quantity collected has a master calendar assigned to it - a month field  Jan - Dec

      Quantity dispatched has a separate master calendar assigned to it - a month field Jan-Dec

       

      It seems you cannot plot one of the master calendar times scales as a dimension and use both of the data sets as measures.

       

      Any ideas

      Thanks