4 Replies Latest reply on Aug 12, 2018 6:44 AM by Zhouyi Zhang

    Counting occurrences based on time range

    Angela.Koh

      Hi all! Am stuck with this and hope that someone can help me out!

       

      I would like to count the number of occurrences [Contact] has come in.

      However, it is not so straightforward, there are 2 criteria to it,

      1) Count only when [Contact] appears more than once, +-48 hours from [Start Timestamp]

      2) Count only when [qispo] is different from one another

       

      Here are 2 examples to show:

      So for the second example highlighted in yellow, it fulfills the first rule of +-48hrs and the second rule of having the same qispo.

       

      Really appreciate your help on how to go about creating this formula. Thank you!!

       

      Honorable mentions:

      Zhouyi Zhang