Jump to content

Need to calculated column C at each different point in time

Carolina Sierra

Recommended Posts


I have a time column, and I need to calculate if column A (operator) has less or more than 3 at that particular time unique values of column B (Rig).

I was thinking i could make the unique count into a column and then check that column to see if the column is >3 or less than 3. Any help is appreciated.

UniqueCount([Rig]) OVER (Intersect([Operator],All([Time])))

Link to comment
Share on other sites

  • 4 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...