Cody Hammond Posted September 30, 2019 Share Posted September 30, 2019 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 More sharing options...
Gaia Paolini Posted October 1, 2019 Share Posted October 1, 2019 Try the calculated column: Avg(DISTINCT [Forecasted reserves]) OVER ([Well]) Link to comment Share on other sites More sharing options...
Cody Hammond Posted October 9, 2019 Author Share Posted October 9, 2019 That's what i was looking for, thank you for your help Gaia Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now