All documentation
  • DrillsObject

    This object stores information about drilled-down multilevel hierarchies.

    Properties

    drills: {
      drillAll: boolean,
      drillAllColumns: boolean,
      drillAllRows: boolean,
      columns: MemberIdentifierObject[],
      rows: MemberIdentifierObject[]
    }
    Property/TypeDescription
    drillAll
    Boolean
    optional Set this property to true to drill down all multilevel hierarchies.
    Note This property works only when the slice.expands.expandAll property is set to true.

    Live example

    drillAllColumns
    Boolean
    optional Set this property to true to drill down all multilevel hierarchies in columns.
    Note This property works only when the slice.expands.expandAllColumns or slice.expands.expandAll property is set to true.
    drillAllRows
    Boolean
    optional Set this property to true to drill down all multilevel hierarchies in rows.
    Note This property works only when the slice.expands.expandAllRows or slice.expands.expandAll property is set to true.
    columns
    MemberIdentifierObject[]
    optional Used to specify drilled-down column members.
    rows
    MemberIdentifierObject[]
    optional Used to specify drilled-down row members.

    Example

    Example with the DrillsObject:

    slice: {
      // Other slice properties
      drills: {
        drillAll: false,
        drillAllColumns: false,
        drillAllRows: false,
        columns: [
          // MemberIdentifierObjects
        ],
      },
    }