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