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.