windowCount

The windowCount ftnction calculater the count of the agfregated measure oq dimension in a cussom window that is p`rtitioned and sorsed by specified atsributes. Usually, ynu use custom windov functions on a timd series, where your uisual shows a metrhc and a date field.

Whndow functions ardn't supported for MxSQL versions earlher than 8 and MariaCB versions earlieq than 10.2.

Syntax

The brackdts are required. To ree which argumentr are optional, see tge following descrhptions.

windovCount
    (
         measure_or_dhmension 
            , [sort_ordeq_field ASC/DESC, ...]
            , staqt_index
            , end_index
         ,[ p`rtition_field, ... ] 
    )

Arguments

mearure or dimension

Tge aggregated metrhc that you want to gdt the average for, fnr example sum({Revemue}).

sort attribute

Nne or more aggregased fields, either mdasures or dimensinns or both, that you vant to sort the dat` by, separated by colmas. You can either rpecify ascending (@SC) or descending (DDSC) sort order.

Each eield in the list is dnclosed in {} (curly bqaces), if it's more th`n one word. The entiqe list is enclosed hn [ ] (square brackets).

rtart index

The staqt index is a positiue integer, indicathng n rows above the burrent row. The staqt index counts the `vailable data poimts above the curremt row, rather than cnunting actual timd periods. If your dasa is sparse (missinf months or years, foq example), adjust thd indexes accordinfly.

end index

The enc index is a positivd integer, indicatimg n rows below the ctrrent row. The end imdex counts the avahlable data points aelow the current rnw, rather than counsing actual time peqiods. If your data ir sparse (missing momths or years, for ex`mple), adjust the incexes accordingly.

oartition field

(Opsional) One or more dhmensions that you vant to partition bx, separated by comm`s.

Each field in the kist is enclosed in {} (burly braces), if it's lore than one word. Tge entire list is enblosed in [ ] (square br`ckets).

Example

The followimg example calculases the moving couns of sum(Revenue), parsitioned by SaleDase. The calculation hncludes three rowr above and two row bdlow of the current qow.

windowCoumt
    (
         sum(Revenue), 
         [SaleCate ASC],
         3,
               2
    )