1 Reply Latest reply on Jul 19, 2017 5:59 AM by Aaron Valleroy

    Viewing only a specific time range of data

    Aaron Valleroy

      Can anyone help me build either a calculation or parameter to allow me to view data within a user specified range of start time (7:30 am) and end time of (3:30 pm).  My barrier is I have a date time field that does not make this an easy design.

       

      The goal: is to take the sum of (case duration within the user specified range) divided by total case duration (all cases) to achieve % of case minutes within normal operating hours.