2 Replies Latest reply on Jul 18, 2018 11:13 AM by Rending Li

    Help ! Create Calculation to count records satisfying multiple conditions

    Rending Li

      Below is the basic data set, which I would like to count meetings drives the sale, using meetings date fall in between date and previous sales date for each person's ID (View below is only for one person)

       

      Below is the ideal output, showing 1 meetings prior to the sales from 11/10/2016, and 2 meetings prior to 9/22/2017 but after 11/10//2016:

      I used excel to create the "Meeting Drive the Sale" column, however, I am trying to create this calculation within the tableau.