Window Calculation

Window calculation is performed after basic calculations such as sum, average, minimum, maximum, percentile, count, and distinct count.

Calculation Types

Window calculation supports the following types of calculations:

• Sum
• Average
• Minimum
• Maximum
• Percentile

Partitioning Criteria

Window calculation supports partitioning criteria including grouping dimensions and comparison dimensions. The partitioning criteria can be empty or include the full set.

If a dimension field is deleted, the corresponding dimension in the partitioning criteria will be automatically deleted.