Amazon QuickSight launches new analytical functions, Athena Workgroup and Presto VPC connector support

Amazon QuickSight makes available new math functions to perform advanced statistical calculations. These functions include logarithms (log()), natural logarithm (ln()), expotent (exp()), square root (sqrt()) and absolute (abs()). Additionally, QuickSight now supports level aware aggregations on RANK, DENSE RANK and PERCENTILE RANK functions. With this, you can compute these functions on your business metrics irrespective of the filters applied and aggregations performed on your visuals. To learn more, see here.