All documentation
  • API Reference for older versions
  • 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/TypeDescription
    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

    ColumnSizesObject
    RowSizesObject
    FilterObject
    ValueSortingObject
    sortValues()