I have some duration date stuff I am working on, but in some very limited cases there are dates in the data (probably wrong, but we have to work with it for now) that are say step 4 in a process, but which have a date significantly before the first step.
What I am trying to do is tell tableau that if the date for a step not named "step 1" has a date before that of step 1, I want you to use the date from step 1 as the start date, otherwise just use MIN([Start Date])
I am pretty sure this is an LOD calc I am not getting right in my head.
The generic data that should work is
ProjectStepStart DateEnd DateP113/17/201512/14/2015P123/17/201511/17/2015P134/6/20156/25/2015P146/15/201511/27/2015P1511/2/201512/14/2015P2110/31/20147/30/2015P2210/31/20147/30/2015P234/16/20141/9/2015P2410/31/20147/13/2015P255/4/20157/30/2015P3111/14/20147/14/2015P3211/14/20147/14/2015P339/9/20141/23/2015P3411/14/20146/26/2015P355/30/20157/14/2015
You can see where P2 and P3 Step 3 is "before" Step 1 which is not possible. Given that some of this data is very old with no real ability to fix it easily, we are relegated to making anything that isn't step 1 with a date before step 1 have the same start date as step 1.
appreciate the help on this.
Hi, Justin
Please find my solution attached as well as the screen shot
Hope this could help
ZZ
