Hi,
I'm struggling to find a function in SAP HANA that can be used to create a percentile. I'm looking for something similar to the percentile_desc function in oracle that can create a percentile based on a certain subsets of the data.
What I'm exactly looking for:
Example, I have a table with 2 fields country & population of each state within that country
Need to find out the 99th percentile of population (within each country) and impute any value > than that to the 99th percentile.
Any help will be appreciated!
Thanks,
Vignesh