I know how create formula based on an column average but what I need to to is partition this by values in another column:
What I have so far is If(:Rank <= 2, Mean(:Residual), Empty()) which would give me the mean
With the table below I need to partition this to another level and average by the sub-value and the State. How would I modify the formula to achieve the required result in JMP?
Would i need to summarize the values in the columns that i need and use an array to complete this?
I have also multiple runs that are dynamic values - could be up to 5 entries in the run column or only 2....
Go to Solution
The optional arguments of the Col Mean() function works as By-clauses.
Not completely sure of what you want to do, but this formula should give the mean for every level of STATE, SUB_VALUE and Rank<=2:
If( :Rank <= 2,
Col Mean( :Residual, :STATE, :SUB_VALUE, :Rank <= 2 )