It would be useful to be able to have a percentile function: (https://support.office.com/en-us/article/PERCENTILE-function-91b43a53-543c-4708-93de-d626debdddca) and be able to call percentile([Column], 0.25), etc. It would be even more useful to be able to calculate across different groups of data.
I have a large SQL routine that is getting the 1st, median, 3rd percentiles as an aggregate. I can almost replace the entire routine with EasyMorph if it had percentile support
I can try to recreate the formula using pure EasyMorph but it would be preferable to have a function for it or support calling external programs with STDIN/STDOUT without requiring an intermediate CSV file – Run Program - option to supply STDIN and STDOUT format
Sidebar: is any form of scripting on the roadmap?