I have a data table where I am wanting to calculate mean, and have the output sorted (Descending) from a grouped column.
As an example
I.e., Data table
If I summarize as follows:
Data Table( "Example_DT" ) << Summary(
Group( :i, :f, :g, :h ),
Order( Descending, Descending, Descending, Descending ),
Mean( :Values ),
Freq( "None" ),
Weight( "None" )
);
i.e., Selecting Descending
Output is incorrect: Shouldn't Column "i" start with 4 and descend down to 1? (This is the problem I am having with my large data table)
If I try to sort by saying I want column i in ascending order it produces the same table
Data Table( "Example_DT" ) << Summary(
Group( :i, :f, :g, :h ),
Order( Ascending, Ascending, Ascending, Ascending ),
Mean( :Values ),
Freq( "None" ),
Weight( "None" )
);
I am using JMP 16.2.0