les jagielko Posted December 8, 2015 Share Posted December 8, 2015 I'm trying to get a time forward densityranking for a group of rigs which are drilling multi well pads. I onlt want to start the ranking from the currently active well pad and count forward chronologically. I have drill dates, rig assignments and well pad ID's. If([RR_DATE]>Date(DateTimeNow()),denseRank([PAD_ID],"ties.method=first","decending",[DRILLING_R])) This expression almost gets me what I need but the data isnt sorted chronologically so it is just ranking based on the PADID value and not the scheduled drill order. Any help would be appreciated. Link to comment Share on other sites More sharing options...
christopher sawtelle 2 Posted December 9, 2015 Share Posted December 9, 2015 You may want to try switching padid and drilling and see what you get. Link to comment Share on other sites More sharing options...
les jagielko Posted December 9, 2015 Author Share Posted December 9, 2015 I tried that but it just assigns all the rows a value of '1'. I'm certain I need to add a date sort field into the mix using the start drill date field but I've tried it in a nested rank expression and even in a rank / Over expression and have not been able to come up with anything. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 8, 2019 Share Posted February 8, 2019 Hi please upload a sample dataset. Gaia Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now