/    /  Amazon QuickSight – Functions & Operators

Amazon QuickSight – Functions & Operators

 

In QuickSight, functions and operators play a key role in transforming, aggregating, and manipulating data to create meaningful insights.

Functions: Functions in QuickSight are pre-written formulas that perform specific calculations on data. Some examples of functions in QuickSight include SUM, AVG, MIN, MAX, and COUNT. Functions can be used to perform mathematical operations, manipulate text, or perform date calculations.

Operators: Operators in QuickSight are symbols that are used to perform operations on data. For example, the “+” operator is used to add numbers, while the “=” operator is used to compare values. QuickSight supports various types of operators, including arithmetic, comparison, logical, and conditional operators.

By using functions and operators in QuickSight, you can analyze data and gain insights into trends, patterns, and relationships in your data. This can help you make informed decisions and drive better business outcomes.

The following functions and operators can be used to create calculated fields.

  • Operators
  • Functions by category
  • Functions
  • Aggregate functions
  • Table calculation functions