5 Replies Latest reply: Mar 2, 2017 6:18 AM by Sarvesh Srivastava RSS

    Display line graph with two different tables Data

    Supriya R

      Hi,

       

      i have two tables like below

       

      LOAD delivered,

      email_type_id as email_metric_type_id,

      date(floor(date_created),'MM-DD-YYYY') as emaildatecreated;  //date is not continues

      SQL SELECT delivered,

      email_type_id,

      date_created

      FROM EMAILMETRICS;

       

      LOAD

      Date(Date#(Date,'YYYYMMDD'),'DD-MM-YYYY') as [Format Date],  //date is continues till date

          TotalHits;

      SQL SELECT

          Date,

          TotalHits

      FROM TrafficView;

       

      Here in EMAILMETRICS, emaildatecreated is not continuos. [Format Date] is continuos. Now i need to put single  line graph for delivered and TotalHits for last 6 months. How could i do this?