3 Replies Latest reply: Sep 17, 2016 4:30 PM by Bob Mu RSS

    Create a Time Dimension based on Work Shifts

    Alan Farrell

      Hi All,

       

      I have an issue where I am trying to create a new Dimension.

       

      Basically, I have work shifts that start at 7am to 7pm (DayShift) and 7pm to 7am (NightShift) continuously.

       

      I want to create a new dimension based on a Time Field that already exists in my Data Model.

       

      How can I create a dimension, based on the Time Field to show transactions that have occurred in a certain shift.

       

      Regards

       

      Alan