Amazon QuickSight – varIf

Amazon QuickSight – varIf

The varIf() function in Amazon QuickSight is used to calculate the variance of a measure in a dataset, filtered by a set of conditions. Variance is a statistical measure that indicates how much the values in a dataset vary from the mean value.

Syntax

#Start#
varIf(measure, conditions)
#End#

This function takes the following arguments:

• measure: This parameter specifies the measure for which you want to calculate the variance. The measure can be a field or an expression.

• conditions: This parameter specifies the conditions that filter the data you want to use to calculate the variance. The conditions can be one or more Boolean expressions that evaluate true or false.

Suppose you have a sales dataset with the following fields: Date, Product, Sales, and Region. You want to calculate the variance of sales for all sales that occurred in the West region. Here’s an example formula:

Example

#Start#
varIf(Sales, Region = 'West')
#End#

This formula calculates the variance of the Sales field for all sales that occurred in the West region.