7 Replies Latest reply on Aug 7, 2018 7:24 PM by Shinichiro Murakami

    Issue in the dashboard

    Pavan Naik Nenavath

      This dashboard has default fields like Start time(IST), Completion time(IST), SLA Time(IST) or cutoff time.

       

      Requirements and Info of the dashboard:

      If completion time > SLA time then it is Miss otherwise it will be Hit.

      If SLA time is 'No SLA'  that means there is no deadline for completion time and always it will be Hit.

      Start Time and Completion Time are in Date Time Format. SLA time is in Time format indicating only the cutoff time like 00:30, 15:30, 16:30 etc.

      If SLA time is 00:30 that means it is either same or next day of Start time depending on the record.

      All the times are in same time zone IST.

       

      Then created Calculated fields in the order - First: Same day?, Second: Due Time and third :  HIT/MISS.

       

      SCENARIO:

      For some records with SLA Time like 15:00, 18:00, 22:00 the Start Time is After SLA Time.

      So the Due time should be the day of Start Time and same day should be True.

       

      Example: This is what I got in the worksheet.

      Start Time(IST)             Completion Time(IST)                  SLA Time                Due Time                HIT/MISS            same day?

      2/18/2018 15:01:25           2/18/2018 15:20:40                         15:00               2/19/2018  15:00:00          HIT                       False

       

      But this is what I want instead of above

      Start Time(IST)             Completion Time(IST)                  SLA Time                Due Time                HIT/MISS            same day?

      2/18/2018 15:01:25           2/18/2018 15:20:40                         15:00               2/18/2018  15:00:00          MISS                  TRUE

       

      Can someone help with this issue? Attached the workbook.

       

      Thanks