1 Reply Latest reply: Aug 12, 2016 10:18 AM by Sunny Talwar RSS

    Time duration in IF statement

    Conor O'Kane

      I am trying to create an IF statement in my load script that will identify whether a duration between two timestamps exceeded 45 minutes.

       

      What I have tried is:

       

      (resolved_at - "Opened time") * 24 as 'duration',

      If('duration' <= 0.75, 'Met', 'Not Met') as 'SLA',

       

      I have created a table and 'duration' correctly gives the number of hours (in decimal format) between the two timestamps. However, every entry has 'Not Met' in the 'SLA' field.

       

      Clearly there is something incorrect with my number formatting. Any help would be greatly appreciated.

       

      Conor