Anyone who can help please??-Calculated column to Find Next Nearest Date

Hi Spotfire Wizards,

Please help me in calculating a column that can bring me the Next Nearest date from an adjacent ‘END’ column.

Two criteria’s of the SCAN are
1.The scan should only return values that are >= the ‘START’ date column values
2.the Scan should be performed within the ‘RIG_NUMBER’ hierarchy.

Please see below the mockup date with the ‘to be achieved’ column that I am striving to get to.Any help with this very much appreciated. 
Also atatched is the DXP, 

RIG_NUMBER ENTITY STARTDATE END To BE ACHIEVED
29 ILDRENS-WEST 11/6/2014 12/10/2014 12/10/2014
29 ILDRENS-WEST 11/9/2014 1/11/2015 12/10/2014
29 RECT ASSETS  3/16/2015 5/10/2015 4/28/2015
29 RECT ASSETS  3/19/2015 4/28/2015 4/28/2015
29 STER UNIT 50 9/14/2015 11/4/2015 10/11/2015
29 STER UNIT AC 9/16/2015 10/21/2015 10/11/2015
29 STER UNIT 50 9/18/2015 10/11/2015 10/11/2015
29 AJILLO UNIT    2/23/2016  
BDF78 ANKE UNIT AC 3/12/2015 5/11/2015 4/18/2015
BDF78 ANKE UNIT 7H 3/14/2015 4/18/2015 4/18/2015
BDF78 ANKE UNIT AC 3/16/2015 5/28/2015 4/18/2015
BDF78 ANKE UNIT 2H 3/18/2015 4/4/2015 4/18/2015
BDF78 N CHRISTOVAL 7/2/2015 8/3/2015 7/15/2015
BDF78 N CHRISTOVAL 7/4/2015 7/23/2015 7/15/2015
BDF78 N CHRISTOVAL 7/6/2015 7/15/2015 7/15/2015

Attachments

AttachmentSize
Image icon 3-18-2016_3-10-38_pm.png30.05 KB
Binary Data nextbestdate.dxp62.44 KB

(3) Answers

Login