2 Replies Latest reply on Jun 15, 2018 5:40 AM by Bryce Larsen

    Graph doubt

    Abhinav Sharma

      Hi,

       

      I am struggling in getting a desired bar graph.

       

      Sample Data:

       

      Find attached the sample data which has brand, email ids, id number, event_date, delivery, open and click.

       

      Desired output:

       

      Graph 1: I am looking for graphs where I have distinct number of emails per mailing_id per day.

      Graph 2: Graph with unique number of opens per mailing_id delivered that day. (for example, 123@gmail.comffoj@yahoo.com, kfh@aol.com, fho@yahoo.com were delivered on 2018-01-04 so unique number of opens( 2 in this case) to show on the same day they were sent(2018-01-04), which means no matter when it is opened or clicked but if it is sent on some day(get the count of that mailing_id's open and clicks on that day itself).

      Graph 3: Graph with unique number of clicks per mailing_id delivered that day.

       

      Output example:

      Graph 1: Having data

      date                    number of emails delivered

      2018-01-01               1

      2018-01-02                0

      2018-01-03                0

      2018-01-04                4

      2018-01-05                2

      2018-01-06               2

      2018-01-07                2

       

      Graph 2: data

      date                    number of unique opens

      2018-01-01               1

      2018-01-02                0

      2018-01-03                0

      2018-01-04                2

      2018-01-05                1

      2018-01-06               0

      2018-01-07                2