1 Reply Latest reply on Sep 11, 2018 10:54 AM by Deepak Rai

    Choosing the right date dimension

    Raheel Farooq

      Hi All,

       

      I have 2 tables Members and Orders, I want to draw a line chart on a worksheet to address 1) Number of Enrollments and 2) Number of Distinct Members getting 1 or more shipments

       

       

      Table A (Members)

      Member_ID     Member_Enrollment_Date

       

      Table B (Orders)

      Member_ID     Shipment_Type     Shipment_Date

       

       

      which date should I use in the columns ?

       

      attached is the worksheet...Thanks