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.