3 Replies Latest reply on Jun 1, 2015 1:09 AM by Tableau kumar

    Sales Interval Analysis

    Jane Lee

      Hello,

      I'm working on a sales interval analysis, but need help w/ laying out data in Tableau, so I can create calculated fields.  My raw data has the following variables:

       

      Customer Name

      Join Program Date

      Sale Date

       

      However, I need to convert change the layout to

      Customer Name | Join Program Date | 1st Sale Date | 2nd Sale Date | 3rd Sale Date|...and so on...

       

      Can anyone help me w/ this?  I've attached a sample in Excel and what I have in Tableau so far. 

       

      Thank you so much in advance!