Hengshi Documentation

Table of Contents generated with DocToc

• Window Calculations
  • Type of Calculations
  • Basis for Partitioning

Window Calculations

Window calculations are a second level of computation performed after basic calculations like sum, average, minimum, maximum, percentile, count, and deduplication.

Type of Calculations

The types of calculations that window calculations support include:

• Sum
• Average
• Minimum
• Maximum

Basis for Partitioning

The basis for partitioning supported by window calculations includes: group dimension and comparison dimension. The basis for partitioning can be empty or can be the entire set.

After a dimension field is deleted, the corresponding dimension in the basis for partitioning will be automatically removed.

• Choose a group dimension as the basis for partitioning, such as: province

• Delete the group dimension province in the chart configuration

• The corresponding group dimension in the basis for partitioning will be deleted