4 Replies Latest reply on Oct 25, 2018 3:22 PM by Adrian Slade

    How to have one calculated field but dynamic value

    Shraddha Khare

      Hi ,

       

      I have a requirement of calculating last 7 days and last 30 days performnace.

      I have used below logic in filed PERIOD:

      If DATE(SPLIT([SLA Date Time], " ", 1)) = TODAY() 

      then 'TODAY'

      ELSEIF 

      DATE(SPLIT([SLA Date Time], " ", 1)) >= TODAY() - 7

      THEN  "Last 7 Days"

      ELSEIF

      DATE(SPLIT([SLA Date Time], " ", 1)) >= TODAY() - 30

      THEN  "Last 30 Days"

      end

       

       

      Problem:

      If PERIOD is last 7 days , it cant be Last 30 days.

      But actually If something is Last 30 days the last 7 days also should be including in there.

       

      How do i fix this?

       

      Thanks

      Shraddha