Dimensionality
Dimensionality() 用于返回当前行的维度数量。在透视表中,此函数返回包含非聚合内容的总维度列数,即不包含部分总和或折叠聚合。
语法:
Dimensionality ( )
返回数据类型: integer
限制:
This function is only available in charts. The number of dimensions in all rows, except the total which will be 0, will be returned. For all chart types, except pivot table it will return the number of dimensions in all rows except the total, which will be 0.
当在图表的任何表达式中使用此图表函数时,不允许对图表中的 y 值进行排序或按表中的表达式列进行排序。因此,这些排序替代项会自动禁用。当您在可视化或表格中使用此图表函数时,可视化的排序将返回到此函数的排序输入。
示例:
A typical use for dimensionality is when you want to make a calculation only if there is a value present for a dimension.
| Example | Result |
|---|---|
|
For a table containing the dimension UnitSales, you might only want to indicate an invoice is sent: IF(Dimensionality()=3, "Invoiced"). |
- |