All documentation
  • API Reference for older versions
  • ValueSortingObject

    Allows setting sorting for values in a specific row or column.

    Properties

    {
      tuple: string[],
      measure: MeasureIdentifierObject,
      type: string
    }
    Property/TypeDescription
    tuple
    String[]
    Consists of unique names that identify the row/column in the table based on the row's/column's data.
    measure
    MeasureIdentifierObject
    Identifies the measure on which sorting will be applied.
    type
    String
    The sorting type: "asc" or "desc".

    Example

    The example below shows how the ValueSortingObject sets 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",
          },
        },
      },
    }