Need a special offer?Find out if your project fits.
+
API reference
  • API Reference for older versions
  • Table of contents

    MeasureIdentifierObject

    This object is used to identify measures when using different functionality, such as sorting, filtering, or setting table sizes.

    Properties

    {
      uniqueName: string,
      aggregation: string
    }
    Property/Type Description
    uniqueName
    String
    The measure’s unique name.
    aggregation
    String
    The measure's aggregation type.
    If the measure is calculated, set the aggregation to "none".

    Examples

    1) The example below shows how the MeasureIdentifierObject is used to set sorting in a row and a column:

    slice: {
      // Other slice properties
      sorting: {
        column: {
          type: "desc",
          tuple: [],
          measure: {
            uniqueName: "Price",
            aggregation: "sum",
          },
        },
        row: {
          type: "asc",
          tuple: [],
          measure: {
            uniqueName: "Sales",
            aggregation: "sum",
          },
        },
      },
    }

    2) The example below shows how the MeasureIdentifierObject is used for filtering:

    slice: {
      rows: [
        {
          uniqueName: "Country",
          filter: {
            measure: {
              uniqueName: "Price",
              aggregation: "sum",
            },
            query: {
              top: 5,
            },
          },
        },
      ],
      // Other slice properties
    }

    See also

    RecordSizesObject
    FilterObject
    ValueSortingObject
    sortValues()