7 Replies Latest reply: Sep 5, 2013 3:18 PM by KAITLYN WEBB RSS

    Creating graph with 2 axis from multiple data sets

      Hi,

       

      In this scenario, I have 3 tables:

       

      SQL SELECT DATE,

          UNIQUEID,

          RESULT

      FROM TABLE1;

       

      SQL SELECT DATE,

          UNIQUEID

      FROM TABLE2;

       

      SQL SELECT,

          UNIQUEID,

          VALUE

      FROM TABLE3;

       

      These three tables contain values that are shared, the UNIQUEID is shared between all three tables and the DATE is shared between TABLE1 and TABLE2.

       

      I want to plot a graph, that shows the RESULT from TABLE1 and the VALUE from TABLE3, but ONLY for those UNIQUEIDs that are in TABLE2. I assumed I needed to do some sort of JOIN first... But I'm not too certain. The graph should have 2 axis since the numerical value obtained from RESULT and VALUE would need their own respective scales.

       

      Thank you in advance!