4 Replies Latest reply on Jun 15, 2018 8:44 PM by Abhinav Sharma

    Level of Detail doubt

    Abhinav Sharma

      Hello,

       

      Please find attached the excel sample file.

       

      Sample Data: The file contains brand, email ids, mailing_id, event_date, event

       

      Desired Output: delivered_date highlighted in the file in tableau workbook. I am looking for the delivery date of each mailing_id across all its events(delivery, open, click).

      example mailing_id- 12842 has delivered_date 2018-01-01 11:00:00 across all its events (delivery, open, click) and so on.

       

      The input data doesn't have that delivered_date column. Have just created in excel file to show what I am looking for. Want to get delivered_date column in tableau as a calculated field.

       

      Please let me know if you have any questions regarding this.

       

       

      Best,

      Abhinav