I have a column of data that I'd like to separated into 5 categories (well above average, above average, average, below average, well below average). Average would be the mean. The standard deviation between each category would be 1.5.
Select your column and create binning formula
There you can find few different options for the binning
If that doesn't work you can write your own custom formula using Col Std Dev and Col Mean
I think this will work.
As Constant( theMean = Col Mean( :target column ); theSTD = Col Std Dev( :target column ); theBinMatrix = Matrix( -99999999 ) || Matrix( theMean - 1.5 * theSTD ) || Matrix( theMean - 0.5 * theSTD ) || Matrix( theMean + 0.5 * theSTD ) || Matrix( theMean + 1.5 * theSTD ); ); Loc Sorted( theBinMatrix, Matrix( :target column ) )[1];