3 Replies Latest reply on Mar 7, 2016 5:50 AM by Suraj Tripathi

    Creating 30, 60 and 90 Days bins

    Suraj Tripathi

      Hi All,

      I am new to tableau and I am trying to create a report where it shows the sales of consultants.

      I want to calculate sales of 30, 60 and 90 days post 'training end date' and sales of 30, 60 and 90 days before 'training end date'. I want my table like this.

      I tried to use 'dateadd' function but couldn't succeed.

      Any help would be much appreciated.

      Training End Date
      After 30 days Sale
      After 60 days SaleAfter 90 days SaleBefore 30 days SalesBefore 60 days SalesBefore 30 days Sales
      30/6/15$1000$1500$1200$900$950$800
      31/7/15$400$450$600$350$