Member Junction
    Preparing search index...

    Interface QueryPivotConfig

    Full configuration for computing a pivot table over query rows.

    interface QueryPivotConfig {
        ColumnLabels?: Record<string, string>;
        ComparisonPeriodColumn?: string | null;
        ComparisonWindow?: boolean;
        DimensionColumns: string[];
        Grain?: PivotTimeGrain | null;
        HiddenColumns?: string[];
        MeasureColumns: PivotMeasureColumn[];
        TimeColumn?: string | null;
    }
    Index

    Properties

    ColumnLabels? ComparisonPeriodColumn? ComparisonWindow? DimensionColumns Grain? HiddenColumns? MeasureColumns TimeColumn?

    Properties

    ColumnLabels?: Record<string, string>

    Header titles for dimension/time columns, keyed by column; unlisted columns show their key.

    ComparisonPeriodColumn?: string | null

    Optional column name indicating whether a row belongs to the current or comparison period. When not supplied but ComparisonWindow is true, rows are split across available time intervals.

    ComparisonWindow?: boolean

    Whether to calculate comparison window deltas

    DimensionColumns: string[]

    Columns to group rows by

    Grain?: PivotTimeGrain | null

    Time grain for the timeColumn (e.g., 'hour' or 'day')

    HiddenColumns?: string[]

    Dimension columns that take part in grouping but are not displayed — e.g. group by an ID and its display name, show only the name, and still have the ID on each output row.

    MeasureColumns: PivotMeasureColumn[]

    Measures to aggregate per group

    TimeColumn?: string | null

    Optional date/time column to bucket

    Settings

    Member Visibility

    On This Page

    Properties