Is it possible to get column percentiles using pivot? I’m trying to get the top 10% of rows (‘cost’) for Dec, Oct, Nov within a pivot. For example, my table looks like the following and I would like to calculate the top% per month.
ID| cost, cost, cost
1 | $2, $4, $6
2 | $1, $9, $7
3 | $3, $1, $5
To get column percentiles we would want a table calc like this to give us the 90th percentile of each column.
percentile(${table_name.cost}, (1-0.10))
But to be honest I’m a little bit confused by your goal, do you mind sharing a bit more of what you mean by the top 10% of rows?
Is this perhaps similar to what you are looking for?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
