3 Replies Latest reply on Nov 14, 2017 1:41 PM by Jim Dehner

    Creating Project Phases

    Kev Van

      Hi all,

       

      I am trying to create separate groupings of dates by different dimensions, to track hours worked by project by project phase. I would like to be able to see the hours worked for each project for each phase of the project, and have the date ranges like this (hopefully the format works):

       

          

      ProjectPhase 1 StartPhase 2 StartPhase 3 StartPhase 4 Start
      A9-Nov-1531-Dec-1517-Mar-1616-May-16
      B9-Nov-1631-Dec-1622-Feb-1720-Apr-17
      C27-Jul-1631-Dec-1615-Feb-1731-Mar-17
      D9-Sep-1531-Jan-162-Mar-1616-Apr-16

       

      I know I can create reference bands, but it looks like I would need to do them individually, which takes too much time. So I was trying to create a calculated field to name each phase, but I can't get it to work:

       

      This doesn't work, but might help to explain what I am trying:

       

      if [Work Date] > date(9/11/15) and [Work Date]< date(1/1/2016) and [Project] = "A" then "Phase 1 A"

      elseif [Work Date] > date(31/12/15) and [Work Date]< date(1/3/2016) and [Project] = "A" then "Phase 2 A"

      ...

       

      Thanks in advance!