Skip to main content

limits

Description​

Optional. Defines the maximum limit for the number of rows and columns in the final dataset

Please, also refer to Limiting data.

Usage​

limits?: {
    rows?: number,
    columns?: number,
    raws?: number
};

Parameters​

The parameters define when to interrupt rendering data:

  • rows - (optional) sets the maximum number of rows in the final dataset; the default value is 10000.
  • columns - (optional) sets the maximum number of columns in the final dataset; the default value is 5000.
  • raws - (optional) the maximum number of source data rows before data is grouped (raw data records used for aggregating); the default value is infinity.
note

Limits are used for large dataset. Limits values are approximate values and do not show the exact values of the rows and columns.

Example​

const table = new pivot.Pivot("#root", {
    fields,
    data: dataset,
    config: {
        rows: ["studio", "genre"],
        columns: [],
        values: [
            {
                field: "title",
                method: "count"
            },
            {
                field: "score",
                method: "max"
            },
        ],
    },
    limits:{ rows: 25, columns: 4 }
});

Related sample: Pivot 2.0. Data limits