3 Replies Latest reply on Aug 23, 2018 7:41 AM by Ankit Bansal

    How to find missing datetime

    Cecilia Gomez

      Hello everybody!

       

      I am trying to build a viz to find "missing" transaction times.

       

      For example, on August 17th I can see transactions starting at 12:00 AM (I can see transactions every minute)... Between 9:05AM and 9:47AM I don't have any transactions.

       

      I want to see that, for this example, from 9:05AM to 9:47AM there are no transactions.

       

                                                     

       

       

      I tried creating a calculated field to display all hours and minutes in a day, but I haven't been successful.

       

      Thoughts?

       

      Attached is a .tbwx with a sample set. Transaction time only includes August 17th as an example.