4 Replies Latest reply: Dec 3, 2015 4:36 PM by Nico Manro Oberholzer RSS

    Duration between two dates

    Raphael Nunes

      Staff, good afternoon.

      Must perform a calculation (difference) between two dates for that stated in the script this way:

       

      LOAD Prefix

            [Name],

            [Start date],

            [End Date]

            Day ([End Date]) the Day,

            Interval ([End Date] - [Start Date], 'hh: mm') the Duration

       

      I need to create a chart with the number of events over 3 hours a day. I then created with the following expression:

       

      count ({<Duration = {"> = 0.125"}>} Name)

       

      I have also noticed that whenever you try to do any kind of calculation with this new variable (Duration) I can make a simple count and sum, but I can not use average.


      How can I fix?

      Thank you!