Create Data Set > Self-Service Data Set > Data Governance > Data Types and Classification

Measure includes values, sales, profits, costs, and so on used for measurement and statistics. In addition, numerical data are divided into measures. Date and time are divided into measures as well. Data types commonly used for measure include:

Data Type	Description
Long	Long integer
Short	Short integer
Integer	Integer
Byte	Byte
Float	Float-point number with single precision
Double	Float-point number with double precision

Measures can also be converted to dimensions following the above rules.

There are many statistical functions supported by measure. It supports all the statistical functions provided by this product.

Function name	Usage
Sum	Sum of all the data returned data set
Count	Count returned to the data set
AccurateDistinct Count	Distinct count returned to the data set
Distinct Count	Cardinality estimation algorithm of big data
Max	Maximum value returned to the data set
Min	Minimum value returned to the data set
Range	Range of the returned data set
Average	Average of the returned data set
Product	Product returning to a data set
Median	Median returning to a given data set
Quartile	Quartile returning to a data set
Mode	Mode returning to a data set or data area
Sum Square	Sum square returning to a data set
Pth Percentile	Pth Percentile returning to a data area
Variance	Variance returning to a data set
Population Variance	Population variance returning to a data set
Standard Deviation	Standard deviation returning to a data set
Standard Error	Standard error returning to a data set
Population Standard Deviation	Population standard deviation returning to a data set
Sum Weight	Sum weight returning to a data set
Weight Average	Weight average returning to a data set
Covariance	Covariance returning to a data set
Correlation	Correlation returning to a data set

7The items need to be automatically divided into dimension or measure include:

1) Refresh Metadata. After create data set and when the metadata is refreshed, all the fields in the data set need to be automatically divided into dimension and measure. The assignment rules are as above. After the assignment, they will be listed on the two nodes on the metadata interface.

2) Create Expression. Create a new expression on the metadata interface. Namely generate fields with scripts. Data type needs to be selected at this time. They will be automatically listed on corresponding node.

3) Create Hierarchy, date hierarchy, data range, or group, and then perform value aliases and delete spaces. The split column will be listed as dimension automatically. The missing value is determined based on the data type of the original field. For the string type, the value is automatically listed as dimension. For the numeric type, the value is automatically listed as measure.

4) Create an expression field when editing dashboard. On the binding interface of the dashboard, it is not divided according to data type, but based on the type of the expression field selected. Detail dimension field refers to dimension. Detail measure field and aggregation measure field are measures.