Do we have support for weighted percentile in Quick Sight?

[akshit97]

Do we have any function that we can use in Quick Sight calculated field to get the weighted percentile?

We are using this method in Athena, but couldn’t find a similar method in Quick Sight?
https://prestodb.io/docs/current/functions/aggregate.html#approx_percentile-x-percentage-same-as-x:~:text=)%3B%0A%2D%2D%5B25%2C30%2C33%5D-,approx_percentile,-(x%2C%20w

[Nico]

Hi @akshit97 ,

welcome to the community

Have you seen this post? I think it is very similar to your question and should solve it:

Percentile question - QuickSight vs Athena

Hey @Max Thanks for the reply (as always! ). Not sure I understand what you mean? Do you want to see the calculation or do you want to see the values used in the calculation? I’m trying to work out what the top (75th) quartile is for our sales people for a given product category and ccy , based on daily average sales. So the question im trying to answer is - how many sales do I need to make (on average per day) to be in the top quartile of sales for the given category. I have …

Best regards,
Nico

If this helped you, please mark my answer as solution. That helpes the community to find solutions faster.

[Xclipse]

Hi @akshit97

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @akshit97

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!