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


            [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!