Get Free Trial
API reference
Table of contents

drillDownCell

drillDownCell(axisName: string, tuple: string[], measureName: string, memberName: string)

[starting from version 2.9.6]

Drills down a specific hierarchy level on the grid and charts.

Parameters

  • axisName — String. The level’s axis. It can be either "rows" or "columns".
  • tuple — Array of strings. The tuple is needed if the hierarchy is nested in another hierarchy. It consists of member unique names that identify the hierarchy’s parent node. See an example on JSFiddle.
  • measureName — String. The measure’s unique name. Use the measureName to drill down a hierarchy level for a specific measure when:
    • The slice has several measures.
    • The hierarchy to drill down is nested in measures.
    If the measureName is not defined, the hierarchy level will be drilled down for all measures in the slice.
    If the slice contains only one measure, set the measureName to null.
  • memberName — String. The name of the hierarchy level to drill down.

Examples

1) Drill down a specific hierarchy level:

flexmonster.drillDownCell("columns", [], null, "2021");

See the full code on JSFiddle.

2) Drill down a specific level in the nested hierarchy:

flexmonster.drillDownCell("rows", ["blue"], null, "USA");

See the full code on JSFiddle.

3) Drill down the second hierarchy level:

flexmonster.drillDownCell("columns", [], null, "geography.[usa].[california]");

See the full code on JSFiddle.

4) Drill down a specific hierarchy level for a specific measure:

flexmonster.drillDownCell("rows", [], "Price", "USA");

See also

drillUpCell
expandAllData
collapseAllData