Skip to content

NTHCOUNT

Returns the number of bottom most descendant elements within a specific parent element within a specified dimension hierarchy.

js
NTHCOUNT(dimension, hierarchy, parent)

Parameters

  • dimension - The name of the dimension.
  • hierarchy - The name of the hierarchy.
  • parent - The name of the parent element.

Examples

js
NTHCOUNT("Time", "Default", "2018")

Note: This will return 365 assuming the Time dimension has a day level granularity.