dense rank by rig and chronologically

[les jagielko]

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.

[christopher sawtelle 2]

You may want to try switching padid and drilling and see what you get.

[les jagielko]

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.

[Gaia Paolini]

Hi please upload a sample dataset. Gaia