prorm API Reference
    Preparing search index...

    Interface PivotOptions

    Pivot options for transforming rows to columns

    interface PivotOptions {
        on: string;
        using: Record<string, AggregateFunction>;
        aggregate?: AggregateFunction;
    }
    Index
    on: string

    The column to pivot on (values become new column names)

    using: Record<string, AggregateFunction>

    Map of column names to aggregate functions

    aggregate?: AggregateFunction

    Aggregate function to use (overrides using if provided)