> For the complete documentation index, see [llms.txt](https://docs.datasuite.vn/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.datasuite.vn/english/features/data-modeling/measures.md).

# Measures

**Measures** are quantitative indicators calculated from data within a **Schema**. When you create a report or chart, the system calculates these measures based on specified filtering conditions or data groupings.

#### **Importance of Measures**

* Enable quantitative analysis and data comparison.
* Serve as the foundation for building reports and charts.
* Support data-driven decision-making.

#### Default Measures

FPT Data Suite provides **default measures** for each **dimension** in a schema.

**For dimensions with data types: Date, Datetime, String, or Boolean, the following aggregate functions are supported:**

* COUNT
* COUNTDISTINCT
* MIN
* MAX
* COUNTROLLINGWINDOW
* COUNTDISTINCTROLLINGWINDOW

**For dimensions with data types:  Number, or Double, the following functions are supported:**

* COUNT
* COUNTDISTINCT
* SUM
* AVG
* MIN
* MAX
* COUNTROLLINGWINDOW
* COUNTDISTINCTROLLINGWINDOW
* SUMROLLINGWINDOW
* AVGROLLINGWINDOW

#### Custom Measures

FPT Data Suite supports three types of custom measures:

1. **Basic Measure**\
   Calculated based on one or more columns of numeric data combined with aggregate functions (such as SUM, COUNT, AVG, etc.).
2. **Filter Measure**\
   Dynamically adjusts filter conditions based on the context of each report.\
   Instead of using fixed filter values, this type of measure utilizes user-selected variables (e.g., time, region, segment) to generate contextual results.
3. **Formula Measure**\
   Created using custom formulas, allowing users to combine multiple measures — even across different schemas — to produce advanced analytical metrics.