Skip to main content

Dimensionality - chart function

Dimensionality() returns the number of dimensions for the current row.

Syntax:  

Dimensionality ( )

Return data type:integer

Limitations:  

This function is only available in charts. The number of dimensions in all rows, except the total which will be 0, will be returned.

Example:  

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").

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!