Jump to content

Applying an aggregation to multiple entities with repeating constant values

Cody Hammond

Recommended Posts

Given two entities within a data table with multiple repeating lines (bbls/month, by month for example), how do I apply an aggregation between the two for a column of constant values As in, i don't want it to average 100 rows of the same constant value with 50 rows of another repeating constant value, but to just take the two values and return the average.

An attached screenshot shows the issue. If i want an average between the two constant values between wells in column D, the value is differnt than averaging the entire column together. Is there a way to allow Spotfire to recogize the one consant value for each well and average just those two

Link to comment
Share on other sites

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