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

    Counting occurrences based on time range


      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