You can create a measure from almost any column or dimension.
|
Function |
Description |
|---|---|
|
Sum |
Returns the sum of a measure |
|
Min |
Returns the smallest value in a set of values |
|
Max |
Returns the largest value in a set of values |
|
Count (Distinct) |
Returns the number of distinct values in a set of values |
|
Count (All) |
Returns the number of values in a set of values |
|
Average |
Returns the average value of a measure |
|
None |
Allows a numeric dimension to be used as a measure, without aggregation. This type of measure enables each value to be visualized in a graph, which is useful for certain types of graphs. For example, for a scatter plot that displays margin and quantity-sold values, this option displays all points on the scatter plot and shows the spread of individual values that would not be apparent using an aggregation function. Note The aggregation type None is not
supported when using a Connect to SAP
HANA data source.
|