Jump to content

Count the number of active wells over time

Dicman Alfred 2

Recommended Posts

I have a simple problem i hope. I have a display that has well production vs time. All I need is count the number of active wells as a function of time. The number of wells in month 1 = 95 but as we approach month 60 only 3 wells are active.

The well name = API14 The columns that a plotted are Oil and Months , Line by API14

I have tried

UniqueCount([API14]) OVER (Intersect(All([Axis.Line]))) AS [Cumulative Count]

This one gave the total unique API14 over time (95 in this example - light blue line) and not the declining well count as a function of time. Any help

Link to comment
Share on other sites

  • 2 weeks 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...