Forum Discussion

Jos13's avatar
Jos13
Helper III
6 years ago
Solved

DATEDIFF

Hi Team, I have the following data I just wanted to count those records with status = "IN" and the time difference between the dates > 30 minutes for the same mobile number. In this example, ...
Need Help
Tips and Tricks
tex628's avatar
tex628
Community Champion
6 years ago

Did you miss a column in your picture? Theres only one date present

/J

Jos13's avatar
Jos13
Helper III
6 years ago

Hi tex628 ,

 

There is only one date column in the table. It indicates the date and time an issue came. I just wanted to count the issues only once that came from the same mobile number within 30 minutes. Issues with status "IN" are considered for the calculation.

 

Thanks

Jos

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    Alright, 

    So if theres 5 IN calls for the same number, are the 1's in the correct place?: 

    10:00 - 1

    10:15
    12:15 - 1
    12:30
    13:15 - 1

    • Jos13's avatar
      Jos13
      Helper III
      6 years ago

      Hi tex628 ,

       

      Yes they are.

      • Jos13's avatar
        Jos13
        Helper III
        6 years ago

        The gap between the calls from the same mobile number should be greater than 30 minutes in order to count it once. And the status should also be "IN".