Amazon QuickSight – Exp

The exp function in Amazon QuickSight is used to calculate the exponential value of a given expression. The function takes one argument, which is the input expression that you want to calculate the exponential value for.

Syntax

#Start#
exp(expression)
#End#

This function takes one argument

• expression: parameter is the input expression for which you want to calculate the exponential value. The expression can be a numeric value, a field from your data source, or an expression that returns a numeric value.

When you apply the exp function to an expression, QuickSight calculates the exponential value of the expression and returns the result. The exponential value is calculated as e raised to the power of the input expression, where e is the mathematical constant known as the Euler’s number, approximately equal to 2.71828.

For example, if you have a data set that includes a column for sales figures and wants to calculate the exponential growth rate of the sales figures over time, you can use the ‘exp’ function to calculate.

Example

#Start#
exp(avg(SalesFigures))
#End#

This expression would calculate the average of the SalesFigures column, and then calculate the exponential value of that average. The result would be the exponential growth rate of the sales figures over time.