How to do Quartiles in the script

[#1]

Good day,

I´ve this app that has the following columns USERID,monthtx and amounttx which has the amount of money spend on any given month.

so my goal is categorize or organize with quartils the user upon the amount they spend throught out six month period which is a data range that i have.

How do i do that.?

the total rows is aprox 12 millons..

any help will be appreciated.

JuanD

[Gysbert_Wassenaar · Accepted solution]

You can use the fractile function to calculate the quartile values: fractile(Amount,.25).