Need a special offer?Find out if your project fits.
+
All documentation
API reference
  • API Reference for older versions
  • sortValues

    sortValues(axisName: String, type: String, tuple: Array, measure: MeasureIdentifierObject)

    [starting from version: 1.4]

    Sorts a specific row or column in the compact form, the classic form, and the chart view.

    Use the setFlatSort method for sorting in the flat form.

    Parameters

    Parameter/Type Description
    axisName
    String
    Specifies which axis should be sorted: rows ("rows") or columns ("columns").
    type
    String
    Specifies the sort order of a row or a column: ascending ("asc"), descending ("desc"), or unsorted ("unsorted").
    tuple
    String[]
    Members' unique names that identify a row or a column.
    measure
    MeasureIdentifierObject
    Specifies which measure from the slice should be sorted.

    Examples

    1) Sorting a specific column in ascending order:

    flexmonster.sortValues(
      "columns",
      "asc",
      ["category.[bikes]", "color.[red]"],
      {"uniqueName": "Price"}
    ); 

    Check out on JSFiddle.

    2) Remove sorting of a specific column:

    flexmonster.sortValues(
      "columns", 
      "unsorted",
      ["category.[bikes]", "color.[red]"],
      {"uniqueName": "Price"}
    );

    See the full code on JSFiddle.

    See also

    getSort
    sortingMethod
    setSort