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

# Creating Project Phases

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):

 Project Phase 1 Start Phase 2 Start Phase 3 Start Phase 4 Start A 9-Nov-15 31-Dec-15 17-Mar-16 16-May-16 B 9-Nov-16 31-Dec-16 22-Feb-17 20-Apr-17 C 27-Jul-16 31-Dec-16 15-Feb-17 31-Mar-17 D 9-Sep-15 31-Jan-16 2-Mar-16 16-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"

...

• ###### 1. Re: Creating Project Phases

Kev

Have you tried pivoting your data so you have 3 columns - the first is project, the second is phase and the third is start date -

you will find it much easier to do your data check

Jim

• ###### 2. Re: Creating Project Phases

Thanks for the quick response. I'm not sure I follow, but the "phases" is what I need to define, based on date ranges and the given projects.

• ###### 3. Re: Creating Project Phases

Yes I understand but your data is not well  structured to do that -

Pivoting the data will put it into a structure where you can compare date in a single column to your check data and determine which phase you are in rather than trying to create a complicated series of if statement to check a series of separate dimensions

see the link below on how to pivot

Jim