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.




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