1 of 1 people found this helpful
One way that this can be done is to create a calculated field similar to the following and use it in place of Date on the columns shelf:
if Well=2 then Date elseif Well=1 then dateadd('day', -11, Date) end
Hope this helps a bit!
Thanks for the suggestion Tracy. That does work in this case, but what I really was looking for is a way to do this dynamically, with more than 2 wells (I apologize - I should have specified that originally).
In your example calculation, you looked at the data and saw that the offset in start dates of the wells was 11 days, so you hard coded that value. Is there a way to write the calculation to set that offset value for each well based on the first date that contains a production value (maybe by setting a parameter)? Obviously, it would be easier if my database included another dimension to specify this start date (and I'm working with IT to add it to the database), but until then, I'm hoping you guys can help me out with a hack.