Member Junction
    Preparing search index...

    A feature aggregated over a dated child table as of each row's decision day.

    interface WindowedAggregateSource {
        aggregate:
            | "count"
            | "sum"
            | "mean"
            | "distinct"
            | "days-since"
            | "active-at";
        childEntity: string;
        dateField: string;
        endDateField: string
        | null;
        filter: readonly RowFilter[];
        foreignKey: string;
        kind: "windowed-aggregate";
        ownerKeyField: string | null;
        valueField: string | null;
        voidedAtField: string | null;
        windowDays: number | null;
    }
    Index

    Properties

    aggregate: "count" | "sum" | "mean" | "distinct" | "days-since" | "active-at"
    childEntity: string
    dateField: string
    endDateField: string | null

    For active-at: the child row is active on day d when dateField <= d and (endDateField is null or >= d).

    filter: readonly RowFilter[]
    foreignKey: string
    kind: "windowed-aggregate"
    ownerKeyField: string | null

    Field on the unit row whose value the child's foreignKey matches; null = the row's entity key.

    valueField: string | null
    voidedAtField: string | null

    A child row stops counting from the day this date field reaches (e.g. the order's reversal date).

    windowDays: number | null

    Window (d − windowDays, d]; null = everything on or before d.