@perspective-dev/client
    Preparing search index...

    Type Alias WindowSpec

    The serialized form of [WindowSpec].

    type WindowSpec = {
        aggregate: string;
        alpha?: number | null;
        column: string;
        cumulative?: boolean | null;
        offset?: number | null;
        order_by?: WindowSort | null;
        partition_by?: string[];
        range?: number | null;
        rows?: number | null;
    }
    Index

    Properties

    aggregate alpha? column cumulative? offset? order_by? partition_by? range? rows?

    Properties

    aggregate: string
    alpha?: number | null

    Smoothing factor in (0, 1] for ema.

    column: string

    The input column - either a real Table column or an expression alias from the same ViewConfig.

    cumulative?: boolean | null

    true frames all rows from the partition start through each row. Default can be omitted.

    offset?: number | null

    Row offset for lag/lead (default 1).

    order_by?: WindowSort | null

    The Table column which orders each partition, and the direction. This orders rows WITHIN the window frame only — it does not reorder the View, which is what the view-level sort does.

    partition_by?: string[]

    Columns whose distinct value tuples partition the rows; empty partitions the whole Table as one group.

    range?: number | null

    A frame of the rows whose order_by value lies within range of each row's, requiring a numeric or temporal order_by. Mutually exclusive with rows and cumulative.

    rows?: number | null

    A frame of the rows preceding each row, plus the row itself. Mutually exclusive with range and cumulative.

    Settings

    Member Visibility

    On This Page

    Properties