Jump to content

dense rank by rig and chronologically

les jagielko

Recommended Posts

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.


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

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

  • 3 years later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...